mercredi 30 mars 2016

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

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

Aucun commentaire:

Enregistrer un commentaire