Vlookup formula with more than one value to lookup.

[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

 

[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

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

 

[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 -

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

Thanks!!!!
William G

 

[Ken Johnson]

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

Thanks!!!!
William G

You're welcome.
Thanks for the feedback.

Ken Johnson