Exel reference formula required?

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I wonder if any one can help?

I want to list two columns on (sheet 2)

Column A = Stock Codes e.g. SSTHAR-143
Columb B = Stock Description e.g. 160GB Hard Disk Drive SATA 7200RPM

I then want to type in Column B on (sheet 1) the reference number 'SSTHAR-143' and have the adjacent field fill in automatically with the description.

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi
Use
=Vlookup(B1,sheet2!$A$1:$B$100,2,false) in sheet 1 description field cell where B1 refers to your item code and sheet2!$A$1:$B$100 referes to database