Vlookup

[tgebert]

Hello!

I have 2 spreadsheets (A=Response Database & B=Mail List Database) and I am trying to pull information from B to A. I need to enter information in column G - in spreadsheet A from column G from spreadsheet B based off of the information in column C - spreadsheet A. My formula is =VLOOKUP(C2,'Mail List'!C1:G25,5,FALSE) which is working a it should, but I have realized that I can have duplicate information in column C and now need to reference column F in spreadsheet B which is the job #.



Can someone help me figure this out?

Thank you,

Tina

 

[yellowizer]

You need to combine the lookup values into a single unique value (columns C & F) on the second sheet. This means you would need job # on the first table as well. Then you can structure the lookup off of the unique values.

 

[tgebert]

You need to combine the lookup values into a single unique value (columns C & F) on the second sheet. This means you would need job # on the first table as well. Then you can structure the lookup off of the unique values.

I don't think that I completely understand what you're saying.

I can email you what I am trying to do?

Thank you,
Tina