Cell Referencing

[Maverick1501]

I need to create a formula whereby if cell 'A1' = 123456, then cell 'B1' automatically changes to a description. i.e. a prodcut description. This I have done using =IF(A23=Sheet1!B2,Sheet1!A2,). However, this only seem to work when referencing one cell. I need to be able to reference many cells so typing in different codes will bring up different descriptions. Any ideas?

 

[Jon von der Heyden]

Hi Maverick1501 and welcome to the board!

I believe you are after a VLOOKUP:

Excel Workbook
	A	B	C	D	E
1	123456	Product 1		Table
2				123456	Product 1
3				123457	Product 2
4				123458	Product 3
sheet

Excel 2003

Cell Formulas
Range	Formula
B1	=VLOOKUP(A1,D2:E4,2,)

In this example, the lookup value is A1, being sought in the table in columns D & F. It looks for a match in the left most column of the lookup table (therefore column D) and returns a value from the 2nd column of the table (therefore column E).

I do suggest you read up on the capabilities and sytax of VLOOKUP in your help file.

 

[Maverick1501]

Just what I wanted! Thanks.