Match and Vlookup

[nathanB]

Hi all,

I am having an issue, by which all I want to do is display a persons job title using a vlookup of their employee ID. I have created a sample workbook, which has descriptions of the issues I am having when trying to do this.

Any help is greatly appreciated!MatchLookup Problem.xlsx

[dilipandey]

Hi NathanB,

Use the below formula:-

Please Login or Register  to view this content.

Enter it using ctrl shift enter key combination.


See the attached workbook...
MatchLookup Problem.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[benishiryo]

hi nathanB, an alternative non-array formula:

Please Login or Register  to view this content.

[nathanB]

Works a treat, thank you very much dilipandey. Had to modify it a little to suit my report but it works wonders. Well earned +rep!

[dilipandey]

you are welcome nathanB..

Cheers

thanks for the rep


Regards,
DILIPandey

<click on below 'star' if this helps>