IF(VLOOKUP) vs INDEX(MATCH) to find values based on multiple criteria

IIJHFII

I'm trying to perfect one, but so far both formulas do not return what i'm after. I am trying to create a formula to return a cell in column FHE!E:E such that FHE!C:C matches DS!C5 and DS!G5="text".

I have tried 2 methods, IF(VLOOKUP):

=IF(DS!G5="text",VLOOKUP(DS!C5,FHE!A:Z,5),"")

This produces the same number (-81) for all cells where DS!G5="text" but -81 is not the value it should bring back from FHE!E:E

Also INDEX(MATCH):

=INDEX(FHE!E:E,MATCH(DS!C5 & DS!G5,FHE!C:C & "text"))

This just produces #VALUE

Any help on where I might be going wrong would be greatly appreciated

Sedss

Make sure your lookup table starts with the left most column being the one you want to lookup from. Also add an additional argument to the lookup for exact match, i.e put ,0 at the end of your Vlookup bracket. See if that works and let me know! :)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Highlight values based on multiple criteria

Find duplicate values in MySQL based on combination criteria

Find duplicate values based on specific criteria

Find duplicates based on multiple criteria and mark them

Values in a column to rows based on multiple criteria

Extracting values based on multiple criteria in Google Sheets

Count unique values in excel based on multiple criteria

Merging different values based on multiple criteria

Count distinct values based on multiple criteria

Cumulative sum of unique values based on multiple criteria

Pandas - How to find row values based on new column data and self-merge with multiple criteria

Excel Finding Average value based on multiple criteria (multiple values)

Python, Pandas - count values based on multiple criteria in row and multiple columns

How to lookup multiple values based on multiple criteria in one cell?

SQL Server find sum of values based on criteria within another table

Excel - Find the Top 'X' amount of values based on criteria

Oracle SQL Find Sequential Values Based on Criteria in Another Column

Find distinct IDs based on criteria of multiple columns [ANSI SQL]

Find or get the second lower value based on multiple criteria

Excel - find MAX value in multiple row ranges based on several criteria

Find outliers in dataframe based on multiple criteria and replace with NaN using python

Selecting distinct field value based on multiple field values criteria

Getting multiple values per group based on two criteria

Pandas DataFrame: Fill NaN values based on multiple criteria

filtering multiple values based on one matching criteria in a different column in excel

Sum unique values based on multiple criteria google sheets

Update cell values based on dependent drop down lists/multiple criteria

How to group multiple rows based on some criteria and sum values in R?

How to copy values based on multiple cell criteria to another Sheet