Is this possible to do in excel?

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

I have to excel worksheets. The first sheet has to columns that have a part
number and a cost field. The second worksheet also has a part number and a
cost column except that the cost column has no values in it. What I want to
do is to create some sort of query or program on the second worksheet that
will try to match part number of the 2nd worksheet to the first. If it
finds a match, I want it to populate the cost field with the quantity that
is in the 1st worksheet.

Is this possible? Is so, how do you do it?

Thanks,
Jasper
 
Assume...

Sheet1: Part No. is in A2:A100 and Cost is in B2:B100
Sheet2: Part No. is in A2:A20 and want to populate B2:B20 with Cost

Sheet2!B2 = Vlookup(A2,Sheet1!$A$2:$B$20,2,False)

This will lookup up the the Part Number on Sheet1 and move one column
to get the Cost.

If it's possible the Sheet2 Part No. may not be listed on Sheet1, the
you could use:

=If(IsError(Vlookup(A2,Sheet1!$A$2:$B$20,2,False)),"No Match",
Vlookup(A2,Sheet1!$A$2:$B$20,2,False))
 
Back
Top