Is there anyway to use VLOOKUP in reverse order?
Instead of having VLOOKUP look for the value in the left most column of an array for the target value and return the value on the right, look in the right most side of an array and return the left most value?
Last edited by sinspawn56; 10-22-2009 at 05:37 PM. Reason: Added Attachment
Simple answer...no... you'd have to look into using INDEX with MATCH
yes,use index/match
see
http://www.contextures.com/xlFunctions03.html
if you get stuck post an example of what you have and someone will do one on your data to help
"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
I've added an attachment that is an example of what I am trying to accomplish.
If you're wanting to count rather than lookup maybe I'd suggest using DCOUNTA
=SUMPRODUCT((Sheet1!C2:C200=B2)*(Sheet1!B2:B200=A2)*(Sheet1!A2:A200="A"))
thats if you want to count on both criteria john and 10888
Much more gracefully done than my suggestion
then again if john always =10888 ,pat always = 22222
and so on
=SUMPRODUCT((Sheet1!B2:B20=A2)*(Sheet1!A2:A20="A"))
Very well played sirs. Thank you both for your feed back and contributions. It seems to be playing out well in real world application and for my purposes.
I need help converting school results back from numbers averaged to a table with equivalent letters. I used VLOOKUP to get the equivalent numbers e.g. A+ =15 to E- = 1 then averaged results but now I want to go back to award an A to E but reverse is not working... any suggestions?
janisezw,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks