Hi all,
I have a table which cannot be changed. I want to use vlookup to find prices according to the item numbers. Usually vlookup can only take columns to the right of the look up value but my vlookup value is to the left.
Any idea how that may work?
I am looking forward to hearing from you.
Thanks in advance.
Last edited by Mengo85; 12-19-2012 at 08:25 AM.
Use Lookup formula
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
INDEX and MATCH are your friends here. Have a read up on how they work.
I tried the match and index formula but that seems only to work when the columns are next to each other. My columns are 4 columns apart. Any ideas?
=index(z1:z100,match(a1,C1:c100,0)) would match in col c and return a value from corresponding row in col z
"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
It works, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks