Exel reference formula required?

Closed

starsky2009 - Jun 11, 2009 at 03:05 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 14, 2009 at 09:00 AM

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.

Exel reference formula required?
Logitech formula vibration feedback wheel driver - Download - Drivers
Excel grade formula - Guide
Number to words in excel formula - Guide
Credit summation formula - Guide
Date formula in excel dd/mm/yyyy - Guide

1 response

Answer 1 / 1

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jun 14, 2009 at 09:00 AM

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

How to calculate positions (1st,2nd,3rd...) in Excel

A required download missing

How to calculate position (1st,2nd,3rd) in excel....?

itunes 64 bit problem

Similar discussions

Subscribe To Our Newsletter!