Hi, please refer to the attached excel.
Is there anyway to return the value from the correct column "Bravo" if I key in the type of either "RCS302" or "RCS502" and a value from "Alpha" column
Thanks for your help
Hi, please refer to the attached excel.
Is there anyway to return the value from the correct column "Bravo" if I key in the type of either "RCS302" or "RCS502" and a value from "Alpha" column
Thanks for your help
Last edited by xWiZardx; 08-27-2015 at 11:22 AM.
Try this:
Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
=index($a$3:$e$63,match(h4,index($a$3:$e$63,0,match(h3,$a$1:$e$1,0)),0),match(h3,$a$1:$e$1,0)+1)
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!
Try ...
=IFERROR(IF($H$3=$A$1,VLOOKUP($H$4,$A$3:$B$63,2,1),VLOOKUP($H$4,$D$3:$E$63,2,1)),"")
assumes only your 2 tables and will find closest match if there is not an exact match.
Thank you all for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks