I will appreciate your help to solve the problem as shown in attachment.
thanks in advance.
I will appreciate your help to solve the problem as shown in attachment.
thanks in advance.
Last edited by canada123; 07-17-2011 at 09:49 AM. Reason: To verify another option
How about with your sample...
=VLOOKUP(E13,$B$7:$C$11,2,0)
HTH
Regards, Jeff
I replaced the cell that says "yellow" with a formula, which references A13 containing the value 3 that you are looking for. However, your example workbook does not at all match the title of your thread.
which do you wish to get yellow or 3?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Did you try the Vlookup?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks