automatic fill-in question

A

Adrienne S.

I would like to make a spreadsheet that fills in automatically with a
description when I type in a number.

How would I set up my spreadsheet to do this?

thanks,
Adrienne
 
J

JulieD

Hi Adrienne

you can use the VLOOKUP function to match a value with a list of values and
return related information. To do this you need a list of all your
"numbers" (ie the product numbers) say in column A and the related
description in column B ... do this on Sheet 2 of the workbook.

On sheet 1 enter the product number in say cell A2 and the following formula
in B2 to return the description
=VLOOKUP(A2,Sheet2!A1:B100,2,0)
this says lookup up the value in A2 in column A of Sheet 2 and return the
information from column B where there is an exact match.

as this will return a #NA error if there is nothing in A2 nest it in an IF
statement
=IF(ISNA(VLOOKUP(A2,Sheet2!A1:B100,2,0)),"",VLOOKUP(A2,Sheet2!A1:B100,2,0))

Hope this helps
Cheers
JulieD
 
Top