VLookup Data in two Sheets

  • Thread starter Thread starter HD
  • Start date Start date
H

HD

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
 
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
 
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
 
Back
Top