reverse vlookup how

[arctushar]

Hello
I want to get value from reference one column and return value by corresponding row from another column. This can be done by vlookup column. But it find value from 1st column and return value from given relative column. That mean find from Left column and return value from right side given column number.

But I want find from Given column number and return value from given left column. For Further detail see the Attached file.

thank You

[NBVC]

Try:

=INDEX($A$1:$A$7,MATCH(F10,$D$1:$D$7,0))

[mshtuhin]

wow thats gr8. for long i used to do find value using vlookup but never think of such excellent formula.

Many many thanks to NBVC

[arctushar]

Thanks NBVC. Solved

[kerrold1]

Hi, I have used this formula and it works great but need it to do one more thing.....
I am using the formula =large('MR Data'!M:M,1) to get my top 10 oldest items from a list of activities and then this formula to populate other fields against it. The problem I have come across is that in the top 10 there are some duplicates so when i do the lookup above they pull the corresponding data to the first one in the list and not each item. How can I do this?
Thankyou in advance, Kerry

[NBVC]

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.