3 Columns F:G:H, Match column 2 & 3 Return value from column 1

[Dtex20]

Hi guys,

I'm having a problem with this lookup, i can't use Vlookup because i'm using other formulas to split the name were there is a space.

I can't use index, match the way i know because there is nothing on the top row. It's just 3 columns.

So Column F:G:H.

I want to:

match D22 to Column G
match D23 to Column H
Return the value in Column F they're all on the same line.


So if G110 matched D22
H110 Matched D23
F110 Value would appear in the cell.

Thanks !

 

[AlanY]

try

=IFERROR(IF(AND(MATCH(D22,G:G,0)=MATCH(D23,H:H,0)),INDEX(F:F,MATCH(D22,G:G,0)),""),"")

 

[Dtex20]

try

=IFERROR(IF(AND(MATCH(D22,G:G,0)=MATCH(D23,H:H,0)),INDEX(F:F,MATCH(D22,G:G,0)),""),"")

Works Perfectly, a little bit of editing with sheet names but exactly what i wanted.

I would've never got that.

Thanks so much man!

 

[AlanY]

you're welcome

 

[rpaulson]

try this:

=IF(D23=INDEX(H:H,7),INDEX(F:F,MATCH(D22,G:G,0)),"")