Greetings.
I am struggling with looking up a value across three columns (three different unique employee ID numbers) and returning the name. The basic vlookup function that I employ is not reading multiple columns.
Any help would be most welcome.
Thank you.
Jacob
How about=INDEX($F$1:$F$200,AGGREGATE(15,6,(ROW($F$1:$F$200)-ROW($F$1)+1)/($A$1:$E$200=H2),1)) you may need to change the ranges.
Thanks Fluff13. Appreciate your time and assistance. T
Edit: Are you still using Excel 2003 as your profile shows? If not please update your profile to show which version. It's important ... for example Fluff's AGGREGATE function was introduced in Excel 2010.
Another way.
In F2 this and filled down.Formula:
=INDEX($D$2:$D$13,MATCH(2,INDEX(1/MMULT(--($A$2:$C$13=$E2),{1;1;1}),0)))
Last edited by FlameRetired; 11-25-2021 at 12:18 PM.
Dave
Thanks Dave. Works perfectly. Appreciate it.
Oops, forgot to check what version was being used.Fluff's AGGREGATE function was introduced in Excel 2010.
@ q8books
You are welcome. Thank you for the feedback and marking your thread Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks