Using vlookup to compare 2 sheets

[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.

 

[RagDyer]

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.