Vlookup formula with more than one value to lookup.
 

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

Vlookup formula with more than one value to lookup.
 

On Mar 13, 7:52 am, William G wrote:
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,FALS E)

Ken Johnson

Vlookup formula with more than one value to lookup.
 

On Mar 12, 3:08*pm, Ken Johnson wrote:
On Mar 13, 7:52 am, William G wrote:





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,FALS E)

Ken Johnson- Hide quoted text -

- Show quoted text -

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

Thanks!!!!
William G

Vlookup formula with more than one value to lookup.
 

On Mar 13, 9:26 am, William G wrote:
On Mar 12, 3:08 pm, Ken Johnson wrote:



On Mar 13, 7:52 am, William G wrote:

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,FALS E)

Ken Johnson- Hide quoted text -

- Show quoted text -

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

Thanks!!!!
William G

You're welcome.
Thanks for the feedback.

Ken Johnson