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