# Vlookup query

#### A Zed

##### New Member
Hi People, just found this invaluable website, and need to post already.

Ok in simple terms I have a sheet with
surname, first name, date of birth, amount, amount, amount.

a second sheet with

surname, date of birth, amount

need to get amount from column 6 in first sheet into column 3 in second sheet, but only if surname and date of birth BOTH match. (mulitple people with same surname)

Id prefer to not merge the two columns, as the resulting sheet actually has to be uploaded into another program and format/layout can not be changed.
Have just overloaded my brain looking at other peoples overdone formulae and require assistance.

I figure it must be simple and doable, as Ive had need for it many times.

Any assistance greatly appreciated.

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Hi People, just found this invaluable website, and need to post already.

Ok in simple terms I have a sheet with
surname, first name, date of birth, amount, amount, amount.

a second sheet with

surname, date of birth, amount

need to get amount from column 6 in first sheet into column 3 in second sheet, but only if surname and date of birth BOTH match. (mulitple people with same surname)

Id prefer to not merge the two columns, as the resulting sheet actually has to be uploaded into another program and format/layout can not be changed.
Have just overloaded my brain looking at other peoples overdone formulae and require assistance.

I figure it must be simple and doable, as Ive had need for it many times.

Any assistance greatly appreciated.

On Sheet2 in C2:

Control+shift+enter...

=INDEX(Sheet1!\$F\$2:\$F\$100,MATCH(1,IF(Sheet1!\$A\$2:\$A\$100=A2,IF(Sheet1!\$C\$2:\$C\$100=B2,1)),0))

Thanks for that, will give it a try.
Anyone else with other options?

Replies
14
Views
1K
Replies
3
Views
678
Replies
1
Views
929
Replies
4
Views
723
Replies
17
Views
1K

1,221,212
Messages
6,158,562
Members
451,498
Latest member
tyshanklin1

### 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