Hi guys,
First, let me thank you all for your assist and this forum for all your help, it has proven very useful.
I can't seem to figure out a formula for a look up, please see attache worksheet and assist if possible.
Thanks you so much!
yayayK
Hi guys,
First, let me thank you all for your assist and this forum for all your help, it has proven very useful.
I can't seem to figure out a formula for a look up, please see attache worksheet and assist if possible.
Thanks you so much!
yayayK
=INDEX($B$3:$E$7, Match(A11, $A$3:$A$7,0), MATCH(B11, $B$2:$E$2,0))
or
VLOOKUP(A11, $A$3:$E$7, MATCH(B11, $B$2:$E$2,0), FALSE)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try...
=INDEX($B$3:$E$7,MATCH($A11,$A$3:$A$7,0),MATCH($B11,$B$2:$E$2,0))
Thank you ChemistB, I just ran into a issue when I try to copy that formula down to Cell C12, do you know why it's returning a #N/A response?
Thank you JohnTopley, I still have that same issue when I copy the formula down.
Last edited by yayayken; 09-08-2015 at 03:39 PM.
Which one? I gave two. Also, exactly what did you type in so I can compare.
ChemistB,
I used the top formula. Please see attachment "v2".
Thank you so much for your time.
yayayK
Because you had an extra space after A123 in cell A12. Remove that and all will be well.
....... I'm sorry, must have did it in a rush.
Thank you for all your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks