Forumlas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a formula to do the following: -

Column A - has stock numbers
Column B - Quantity
Column C - Description

How do I do a formula that will automatically put in the description once I
enter the stock number?

I have another sheet in the same workbook with all of the stock numbers and
descriptions to work from.

Thanks!
 
Use VLOOKUP:

Use Data Validation (DV ) to select your stock numbers.

Assuming your Stock table iis in Sheet2 columns A to C:

If stock number (DV) is in A2:

in B2: =VLOOKUP(A2,Sheet2!A:C,2,0)

to get Quantity

in C2: =VLOOKUP(A2,Sheet2!A:C,3,0)

to get Description

HTH
 
You would use Vlookup in the description column

=VLOOKUP(A2,Sheet2!$A$1:$B$50,2,FALSE)
Drag down as far as rtequired

Where A2 is the stocknumber you are entering and Sheet 2 A1 to B50 are the 2
columns with stock No#s abd descriotions in.



Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dates 3
Extracting from a List 1
make a minus a zero 2
SUM - IF - AND 7
Multiple Worksheets 1
Delete value but not formula 2
Help again 1
is this possible 3

Back
Top