Index & Match
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
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
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you very much!
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
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))
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
Last edited by tgebert; 03-18-2015 at 03:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks