Lookup, match?

  • Thread starter Thread starter jkb66
  • Start date Start date
J

jkb66

I have a value in column A on sheet 3, I want it to match a value in column A
in sheet 1, then I want the corresponding number from column c on sheet 1 to
populate column c on sheet 3.
 
In C1:

=VLOOKUP(A1,Sheet1!A1:C5,3,FALSE)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a value in column A on sheet 3, I want it to match a value in column A
| in sheet 1, then I want the corresponding number from column c on sheet 1 to
| populate column c on sheet 3.
 
jkb66 said:
I have a value in column A on sheet 3, I want it to match a value in column
A
in sheet 1, then I want the corresponding number from column c on sheet 1
to
populate column c on sheet 3.
Click to expand...

To get you started, in cell C1 of Sheet3 put this formula:
=VLOOKUP(A1,Sheet1!A1:C999,3,0)
(Adjust the range A1:C999 to suit your data.)

Copy it down as far as you need for data in Sheet 3.
 
Thank you all that did help part 1 of a 2 part problem!,

same workbook. sheet 3 I have a value in column b that I need to match in
sheet 2 and bring the corresponding value in column b and populate into sheet
3 column d, I had thought I could manipulate these VLookups to suit purpose,
but I keeping getting #REF!
 
Just to add...

If you're going to copy the formula down the column, make sure that the lookup
table range doesn't change:

=VLOOKUP(A1,Sheet1!A1:C999,3,0)
should be:
=VLOOKUP(A1,Sheet1!$A$1:$C$999,3,0)

or if there's nothing else in A:C, you could use the whole column:

=VLOOKUP(A1,Sheet1!$A:$C,3,0)
 
Thank you this has been solved!

jkb66 said:
Thank you all that did help part 1 of a 2 part problem!,

same workbook. sheet 3 I have a value in column b that I need to match in
sheet 2 and bring the corresponding value in column b and populate into sheet
3 column d, I had thought I could manipulate these VLookups to suit purpose,
but I keeping getting #REF!
Click to expand...
 
Back
Top