Vlookup formula with more than one value to lookup.

W

William G

I'm trying to return a value based on what cell has the 'x' marked:

Heavy Gen Purpose Truck >13k lbs
Land
x Light Duty/Truck Trailer
Leasehold Improvements-15 Yrs
Leasehold Improvements-20 Yrs
Machinery
Office Equipment

Cell A3 has the "X", cell B3 is what I want to use to lookup the value
to return the correct depreciation years.

How can I use the vlookup formula to return column B information based
on where column A's 'x' is located?

Thanks for your knowledge.

William
 
K

Ken Johnson

I'm trying to return a value based on what cell has the 'x' marked:

Heavy Gen Purpose Truck >13k lbs
Land
x Light Duty/Truck Trailer
Leasehold Improvements-15 Yrs
Leasehold Improvements-20 Yrs
Machinery
Office Equipment

Cell A3 has the "X", cell B3 is what I want to use to lookup the value
to return the correct depreciation years.

How can I use the vlookup formula to return column B information based
on where column A's 'x' is located?

Thanks for your knowledge.

William
Click to expand...

Use nested vlookups. One vlookup looks up the "X" and returns the
item. This vlookup's returned value will need to be the first argument
of the other vlookup which looks up the item and returns its
"depreciation years".

For example, if the above table's address is A1:B7 and the
"depreciation years" column is the 5th column of another table with
address F1:L100 then...

=VLOOKUP(VLOOKUP("X",A1:A7,2,FALSE),F1:L100,5,FALSE)

Ken Johnson
 
W

William G

Use nested vlookups. One vlookup looks up the "X" and returns the
item. This vlookup's returned value will need to be the first argument
of the other vlookup which looks up the item and returns its
"depreciation years".

For example, if the above table's address is A1:B7 and the
"depreciation years" column is the 5th column of another table with
address F1:L100 then...

=VLOOKUP(VLOOKUP("X",A1:A7,2,FALSE),F1:L100,5,FALSE)

Ken Johnson- Hide quoted text -

- Show quoted text -
Click to expand...

Thank you...that was helpful and worked perfect.

Thanks!!!!
William G
 

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 with value between 2 cells and return greater value. 6
How to lookup with more than 1 value 6
Finding value using greater than, Vlookup, and nested If 2
Using lookup formula using more than one cell 8
Trying to get Vertical Lookup to return more then one value...how? 4
VLOOKUP - Return value of the cell below the formula's answer 1
Lookup in a matrix (with x and y headings) based on value x and y 2
IINDEX and MATCH formula with more than one return value 6

Top