Hi
I have been racking my brains trying to work this out, so could really do with some help.
I need to find a name which could be in either column A or B then give me the data for that row at column 11.
I have been trying to use Vlookup but cannot get it to look for the required name in A or B.
Can someone please help.
Use the IfError formula in conjunction with INDEX, MATCH. See the formula in cell F1 in the attached.
=INDEX(Table1,IFERROR(MATCH(E1,Table1[Name 01],0),MATCH(E1,Table1[Name 02],0)),3)
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
This has been working great for me but i need to tweek it slightly. When it looks up a name, i need it to find a close match but not exact.
For example look up John Dow but will find John Dow agency.
Is this possible and if so can someone please tell me how to tweek the above formula.
Last edited by valks1; 11-18-2020 at 04:25 PM.
Try to combine 2 names then using substitute and Lookup
Quang PT
Wow thanks bebo that looks perfect for what i need.
Many thanks to everyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks