VLOOKUP

J

Jason Morin

=VLOOKUP(A1,E:F,2,0)

will return a value. The cell address of that value is:

=CELL("address",INDEX(F:F,MATCH(A1,E:E,0)))

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP & Data Validation 0
Can I add a formula or function to Vlookup? 1
Help With VLOOKUP 2
trouble with (complicated) vlookup searching another workbook 2
Use & with two formulas 2
Match and Vlookup issue 2
vlookup formatting problem 1
Searching the formula (not the value) for a text string 1

Top