look up help

  • Thread starter Thread starter itty
  • Start date Start date
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
 
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.
 
Back
Top