There was a thread on this just within the last couple of days or so.
Please read the responses from Shg in this thread.
Thanks for the plug, Six Strings. In that post, I provided a formula for looking up catenated cells in catenated columns -- not what the OP is looking for here, by my reading.Please read the responses from Shg in this thread.
I think the OP here is looking to return the 1st, 2nd, 3rd ... match of a VLOOKUP (or the equivalent). I expect it could be cobbled together by using INDEX and MATCH, using some kind of catenation with COUNTIF. I tried briefly, but couldn't finish it. A helper column would certainly work.
adnanriaz, can you post an example?
Entia non sunt multiplicanda sine necessitate.
MS MVP - Excel
Assuming that A2:B10 contains the lookup table, D2 contains the lookup value, and the corresponding values from Column B are to be returned, try the following...
F2, copied down:
...confirmed with CONTROL+SHIFT+ENTER. Note that the number 2 at the end of the formula determines the column from which to return the corresponding values. In this case, the corresponding values are to be returned from the second column or Column B. See the attached file.
Hope this helps!
Please do not post your question in threads started by others - - this is known as thread hijacking.
Always start a new thread for *YOUR* question. If you find it helpful to clarify your needs you can include a link to this ( or any other ) thread.
When starting a new thread be sure to give it a search-friendly title that aptly describes your need.
There are currently 1 users browsing this thread. (0 members and 1 guests)