VLookUp

[INeedHelp1987456]

Hello I'm trying to write a vlook up so that if a value in column c sheet 1 matches a value in column c sheet 2, then the value on the same row in column g sheet 1 will be added to the value on the same row of column g sheet 2.

Thank You!

-R

 

[Joe4]

Welcome to the Board!

Take a look at the VLOOKUP function. Let's say that your data on Sheet1 is in cells C1:G100, and you are looking up a value in C3 on Sheet2. Then enter this formula in G3 on Sheet2:

=VLOOKUP(C3,Sheet1!C$1:G$100,5,0)

It will return an error is it does not find a match. There are different ways you can handle that error, depending on what version on Excel you are on and what you want it to do in the event of no match.

Take a look at Excel's built-in help on the VLOOKUP function for details on how to use the function, explanations of the different arguments, and examples.