Previous Topic Next Topic

Exel reference formula required?

Closed
starsky2009 - 11 Jun 2009 à 03:05
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 14 Jun 2009 à 09:00
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.
Related:

1 response

Réponse 1 / 1
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
14 Jun 2009 à 09:00
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

Similar discussions

itunes 64 bit problem
amazingman849 -
DoucheLeRoux -

16 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Facebook security check
jcfajardo24 -
grac17 -

8 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses