look up help

I

itty

I have two sheet, one having part no and description and other having
part no and quantity on hand. How can I bring quantity on hand to my
sheet which have part no and description
 
J

J.E. McGimpsey

One way:

Say your part number and quantity are in Sheet2, columns A and B.
Assume your part number and description are in Sheet1, columns C &
D, and you want quantity on hand in column E. Then:

E2: =VLOOKUP(C2,Sheet2!$A:$B,2,FALSE)

will return the quantity on hand.
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Creating a Chart on form from selected data in query. 0
Hyperlink fails to open on the first click 0
is this possible in excel 2007 3
Quantity separation 2
Please help me choose a product for the task 2
Help with formula 2

Top