vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

VLOOKUP returns a result to the right a given number of columns from the search column. Is there a way to do a lookup that returns the result by looking to the left of the search column?
 
John,

See the Left Lookups section at www.cpearson.com/excel/lookups.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)



John said:
VLOOKUP returns a result to the right a given number of columns from the
Click to expand...
search column. Is there a way to do a lookup that returns the result by
looking to the left of the search column?
 
You must log in or register to reply here.

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

Help needed 0
Excel IF statement with vlookup 2
vlookup from right to left 2
Excel Trying to do a vlookup with a nested right function on the array 3
Excel vba code to match duplicates 4
Vlookup Function 1
vlookup 1
Combining IF Statement and Vlookup 0

Back
Top