# Looking for some help...

#### mrazsj

##### New Member
I have two spreadsheet that I am working with.

column a = acct/route
column b = date
column c = total units

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.

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### sergioMabres

##### Well-known Member
My best experience comes from using auxiliary column in sheet1 let us say col C =A2&B2 and on sheet2 =vlookup(a2&b2,sheet1CD,2,0)
Sergio

#### SamAnnElizabeth

##### New Member
Try this:

=IF(AND(A1=Sheet1!A1,Sheet1!B1=Sheet2!B1),Sheet1!C1,"")

It says "IF A1 from sheet 1 matches A1 on this sheet (sheet 2) AND B1 on sheet 1 matches B1 on Sheet two, then input the value of C1 here. If it doesn't, leave the cell blank." Adjust the cell references to match your needs.

#### BengalMagic

##### Banned user
I have two spreadsheet that I am working with.

column a = acct/route
column b = date
column c = total units

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.

Code:
``=IF(Sheet1!A2&Sheet1!B2=Sheet2!A2&Sheet2!B2,Sheet1!C2,"")``

Replies
1
Views
94
Replies
5
Views
193
Replies
5
Views
221
Replies
0
Views
158
Replies
2
Views
135

1,195,720
Messages
6,011,292
Members
441,599
Latest member
Jribas

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back