Using vlookup to compare 2 sheets

  • Thread starter Thread starter mooi
  • Start date Start date
M

mooi

Hi all...need a little bit of help. Completely confused here.

I am using the vlookup function to compare values from Sheet 2 Col B to
Sheet 1 Col A. If this proves true I want the values from Sheet 2 Col C
to be the output that would appear on Sheet 1 Col G.

Now what would the vlookup function syntax would look like?


Any help would be appreciated. Thank you!

**I have tried to attach a screenshot but the file is too big.
 
Try this on Sheet1, G1:

=VLOOKUP(A1,Sheet2!$B$1:$C$20,2,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi all...need a little bit of help. Completely confused here.

I am using the vlookup function to compare values from Sheet 2 Col B to
Sheet 1 Col A. If this proves true I want the values from Sheet 2 Col C
to be the output that would appear on Sheet 1 Col G.

Now what would the vlookup function syntax would look like?


Any help would be appreciated. Thank you!

**I have tried to attach a screenshot but the file is too big.
 
Back
Top