Vlookup for two different criteria

[Karnik]

Hi Experts,
Attempting to use two details from consecutive columns using vlookup function,
Something is incorrect
Please help
Thanks
Karnik

[Ali Kırksekiz]

For Sheet1 C5 cell

Please Login or Register  to view this content.

This is an Array Formula confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula.

Then pull down.

[Glenn Kennedy]

Use INDEX-MATCH. This is a n Array Formula, confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[mcmahobt]

Different method, with IFERROR that will return a blank instead of an error if there is no match found:

Please Login or Register  to view this content.

Also an array formula, confirmed with CTRL+SHIFT+ENTER

[TMS]

C5:

Please Login or Register  to view this content.

Array Entered with Ctrl-Shift-Enter rather than just Enter.


Regards, TMS

[TMS]

Variation on a theme:

Please Login or Register  to view this content.

array entered

[Karnik]

Hello, TMS,Mcmahabot,Glenn Kennedy,Ali Kirsikis

what a magnificent variations for solution to my issue !
All array/function works, saved my huge amout of time and struggle.
Thank you all very much
Cheers
Karnik

[TMS]

You're welcome. Thanks for the rep.