Hi,
I am trying to use a formula that will either do a vlookup within a vlookup or will be some sort of match formula, so that I can bring back the desired values into the right fields. I have attached a sample workbook which makes it easier to understand - I am trying to bring the technical names of the attributes into the orange fields.
Can anyone help?
Thanks
Sample.xlsx
M3:
=LOOKUP(2,1/(($C$3:$C$9=$I3)*($D$3:$D$9=J3)),$E$3:$E$9)
Copy down and over as needed.
LOOKUP has the magical benefit of being able to handle arrays and all kinds of crazy expressions nested into it. Through this we can get all the functionality of array logic, and INDEX(match all in one.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Enter formula in M3 and pull it to the right and then down
=INDEX($E$3:$E$8,MATCH(J3,$D$3:$D$8,0))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks