VLookup Data in two Sheets
 

How do I look up vlookup with two sheets one Sheet 1 has everything and in
Sheet 2 I need the description to populate

Sheet 1
Item Description
Bike Bike prod
Train New Train Red
Dog Big Brown dog

Need the vlookup
Sheet 2
Item Description
Bike vlookup from sheet 1 to get the description
Dog vlookup from sheet 1 to get the description

VLookup Data in two Sheets
 

In B column on Sheet 2

=VLOOKUP(A1,Sheet1!A1:B4,2,FALSE)

Alter the ranges and cell values as appropriate and then copy formula down

"HD" wrote:

How do I look up vlookup with two sheets one Sheet 1 has everything and in
Sheet 2 I need the description to populate

Sheet 1
Item Description
Bike Bike prod
Train New Train Red
Dog Big Brown dog

Need the vlookup
Sheet 2
Item Description
Bike vlookup from sheet 1 to get the description
Dog vlookup from sheet 1 to get the description

VLookup Data in two Sheets
 

Hi,

Try something like

=VLOOKUP(A2,Sheet1!A:B,2,)

or for a smaller lookup table

=VLOOKUP(A2,Sheet1!A$2:B$100,2,)

The $ signs are important
--
Thanks,
Shane Devenshire


"HD" wrote:

How do I look up vlookup with two sheets one Sheet 1 has everything and in
Sheet 2 I need the description to populate

Sheet 1
Item Description
Bike Bike prod
Train New Train Red
Dog Big Brown dog

Need the vlookup
Sheet 2
Item Description
Bike vlookup from sheet 1 to get the description
Dog vlookup from sheet 1 to get the description