I need to create a lookup in a table where I need to match one value in one column and another value in one of two columns (boolean: A * (B+C)). I have tried to attached an example.
I have tried using an INDEX MATCH formula, which works, unless the client name is not unique.
Any idea how I can do this, so it will work with not unique names? (The combination of name and item is always unique)
Have you considered adding a couple of helper columns to create a pair of composite name/value text strings? =[@Client]&[@[Item 1]] and =[@Client]&[@[Item 2]]
You then have a pair of columns containing unique values which you can index/match easily, as in the attached.
Kind Regards,
Out of the Hat
"Computers are stupid - they do EXACTLY what you tell them to"
If I've helped you with a problem, please say thanks by clicking the small star icon on the left.
No I had not considered that, but that seems to work. Thank you so much for you help, I knew there had to be a way to do this. I really appreciate your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks