Vlookup with two columns?

[gambils]

Possible to do a v-lookup using "and" to look up both first and last names (currently in two columns)? Alternatively, suppose I could combine first and last... Other ideas?

 

[cyrilbrd]

noticed I placed "a" to "g" instead on Conchio1 to Conchio7. a to g is fine, used this so faster to type.

 

[Andrew Poulsom]

That would be:

=IFERROR(INDEX(INDEX($C$2:$I$6,0,MATCH($A17,$C$1:$I$1,FALSE)),MATCH(1,INDEX(($B$2:$B$6=C$16)*($A$2:$A$6=$B17),),FALSE),0),"")

 

[cyrilbrd]

Thanks Andrew.
Not CSE right? noticed the double index...
MATCH type set to false, why not zero, isn't it the same? Thanks to shed some lights.

 

[Andrew Poulsom]

Yes, FALSE and zero are the same, but I'm pedantic.

 

[cyrilbrd]

but I'm pedantic.

No, I think you are cool.
Thank you for your time. Great learning!