Index & Match

[tgebert]

Hello!

I have 2 spreadsheets (A=Response Database & B=Mail List Database) and I am trying to pull information from spreadsheet B and add this information to spreadsheet A. I need to enter information in column I - in spreadsheet A from column G from spreadsheet B based off of the information in column C & column F - spreadsheet A.

Can someone help me figure this out?

Thank you,

Tina

[Ace_XL]

In I2

=INDEX('Mail List'!$G:$G,MATCH(1,INDEX(('Mail List'!$C:$C=C2)*('Mail List'!F:F=F2),0),0))

Copy down

Also avoid using full column references, use only the range that contains data

[tgebert]

Thank you very much!

[tgebert]

Hi Ace_XL,

You helped me with a formula months ago, but I now have another question.

I need to add additional columns to my formula and not sure how to do this.

Can you assist me?

Thank you,
Tina

[Ace_XL]

Do you mean.... something on these lines

=INDEX('Mail List'!$G:$G,MATCH(1,INDEX(('Mail List'!$C:$C=C2)*('Mail List'!F:F=F2)*('Mail List'!X:X=X2,0),0))

[tgebert]

Hello and thank you so much!

Attached are 2 spreadsheets. One is a Master and the other is Responses.

I am trying to get the Campaign Id column in the Master to generate in the Privacy Code column in the Responses, based off of address and job #, BUT I found an issue with this. I also need to not include the address, but include the city, state and zip because if there is a location like PO Box with similar numbers, my Privacy Code in the Responses is incorrect.

Are you able to help?

Thank you,
Tina