I have two spreadsheet that I am working with.
Spreadsheet 1
column a = acct/route
column b = date
column c = total units
Spreadsheet 2
column a = cust id
column b = iss osd
column c = blank
What I would like to say is... "If column a and column b (on spreadsheet 1) are the same value as column a and column b (on spreadsheet 2) then return the value in column c (from spreadsheet 1) into column c (on spreadsheet 2). Does anyone know what kind of formula a could use with this? I usually use vlookup for things but this is with using two columns matching.
Thank you for your help!
Spreadsheet 1
column a = acct/route
column b = date
column c = total units
Spreadsheet 2
column a = cust id
column b = iss osd
column c = blank
What I would like to say is... "If column a and column b (on spreadsheet 1) are the same value as column a and column b (on spreadsheet 2) then return the value in column c (from spreadsheet 1) into column c (on spreadsheet 2). Does anyone know what kind of formula a could use with this? I usually use vlookup for things but this is with using two columns matching.
Thank you for your help!