Compare, match and fill

  • Thread starter Thread starter jim
  • Start date Start date
J

jim

I need a routine that will compare the values on sheet 1
column A rows 1-30 with values on sheet 2 column A
rows 1-350. When it finds a match I need it to insert a
respective value from sheet 1 column B and insert it next
to the match (column B) on sheet 2.

Example:

sheet 1 column A row 11 has a value of "345-3254" with
a value of "7mm" in the adjacent column B. When it searches
sheet 2 for "345-3254" and finds a match it returns the "7mm"
value next to it in column B.

Thanks,

Jim
 
jim said:
I need a routine that will compare the values on sheet 1
column A rows 1-30 with values on sheet 2 column A
rows 1-350. When it finds a match I need it to insert a
respective value from sheet 1 column B and insert it next
to the match (column B) on sheet 2.

Example:

sheet 1 column A row 11 has a value of "345-3254" with
a value of "7mm" in the adjacent column B. When it searches
sheet 2 for "345-3254" and finds a match it returns the "7mm"
value next to it in column B.

Thanks,

Jim
Click to expand...

In B1 on sheet2 put
=VLOOKUP(A1,Sheet1!A1:B30,2,0)
and copy it down as far as B350.
 
Back
Top