Hello All,
I want to lookup a value from two different columns and Index Emp. Name as shown under the arrow sign. What would be my formula to retrieve The Emp. Names??
Thanks.
Hello All,
I want to lookup a value from two different columns and Index Emp. Name as shown under the arrow sign. What would be my formula to retrieve The Emp. Names??
Thanks.
See the attached, modified spreadsheet. I have added two "helper columns". One does a match on column B and the other either copies that result into itself or does a match on column C. Then, in your second table, if there is a number in the second helper column, it uses that as an index to fetch the name from the first table, otherwise it prints a message saying "not found".
_______________
Floyd Emerson
Business Intelligence Consultant
Melbourne, Victoria, Australia
B13=IFERROR(INDEX(A:A,1/(1/MAX(INDEX(($B$2:$C$5=A13)*ROW($B$2:$C$5),0)))),"")
Try this and copy towards downPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
That's good but what If my Trip Code columns are not adjacent?
Having the Trip Code in the same row is enough to pull employee name.
you need to select all the columns in which you had trip IDs.
you need to change the colored ones
=IFERROR(INDEX(A:A,1/(1/MAX(INDEX(($C$2:$F$5=A13)*ROW($C$2:$F$5),0)))),"")
Great! Thanks a lot..!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks