[Possible]

Hey,

I was wondering is this is possible in Excel 2000

I currently have a spreadsheet that pulls data from one sheet to the next. For example, one sheet has all data, the other one, when I type a sku in the information appears that was put in the data sheet.
What I want to do, is put a whole bunch of addresses in the data sheet, so that on the master sheet, when I type a sku in, the rest of the address shows up.

Can this be done?

Thanks,
Possible

[Advertisements]

Hi Possible,
You can use a VLOOKUP function

=VLOOKUP(B2,Sheet2!$A$1:$B$4,2,FALSE)

Sheet1 - Cell C2 is where the above formula is located
Sheet1 - Cell B2 is where you have typed your sku
Sheet2!$A$1:$B$4 is the range containing your SKU number and associated data
2 is the column number in the above range of the data to return
False is required to ensure exact match


Regards
David

[dsm]

Hi Possible,
You can use a VLOOKUP function

=VLOOKUP(B2,Sheet2!$A$1:$B$4,2,FALSE)

Sheet1 - Cell C2 is where the above formula is located
Sheet1 - Cell B2 is where you have typed your sku
Sheet2!$A$1:$B$4 is the range containing your SKU number and associated data
2 is the column number in the above range of the data to return
False is required to ensure exact match


Regards
David