searching for data from two sources

[duckhunter2847]

good morning everyone.

im new to this site, and i have a question.... im not sure how to phrase it, please be patient with me

i have 2 spreadsheets.

first spreadsheet contains master client data compiled through many yrs of business (name, address, phone etc).

second spreadsheet contains names and addresses of new potential clients.

i want to somehow search the master client file for the new data, to see if weve already done business with them..

not just as simple as ctrl-f mates.

see the master file has 317 thousand entries and the weekly "potential" list can have up to 10 thousand names. i dont want to hit "ctrl-f" 10 thousand times every week...

would it be easier if the data were in a word doc?

also, sometimes the company changes name, but the address is the same, so a tool or something to search not just the name but also the address would help... let me know if ive not made myself clear enough...

so... any help and suggestions are appreciated. thanks!

[zbor]

Good evening

Look here for DQ solution:

http://www.excelforum.com/excel-gene...uplicates.html

For something more you'll need to give more details.
best would be to create and upload an example worksheet (imagine some data but make it similiar)

[duckhunter2847]

Great! thank you! that helped tremendously.
i used the following formula from the thread you linked to above:

Upload2!a2: =ISNA(MATCH(A2,'UPLOAD 1'!A:A,0))

It worked great for what it was intended to do.

...now for a follow up question:
how can i narrow down positive(false) results by also searching for data from another column and only display one "true/false"?

im going to attach a file to show what i mean.

"upload 2" tab has the true/false column
lines 19 and 20 both show false becasue vendor number 1000118715 appears in tab "upload 1"

but i want to match the amount also. so only line 19 displays false (the only entry with that vendor number in "upload 1" is for $600.

Im not sure what to add to the formula i have above, i tried several different things, but kept getting "n/a" or errors... im sure this is a simply addition to the above formula, i just cant seem to get it right.

Let me know if I need to further clarify myself.
Thanks in advance for your help and suggestions.

[zbor]

Sorry, didn't get it...
You looking match and you get false because it's more than one...

And what you do with them further?

[duckhunter2847]

in tab 'upload 2' i have two "falses"
for vendor number: 1000118715
(lines 19 and 20)
one for $ 600.00
one for $ 1400.00

however in tab 'upload 1'
there is only one instance of the vendor 1000118715.

its for $600.00

so what is the formula i should put in 'upload 2' in 'cloumn b' so i only get one "false" (line 19 and not 20)

thanks for your help

[zbor]

how about this:
=IFERROR(VLOOKUP(A2;'upload 1'!$A$2:$E$19;5;FALSE)+E2=0;FALSE())

But lookup function will look only for first matching solution so if you have several it won't find it.. but according for what you asking to, this might be it.

also, if you want opposite TRUE and FALSE just put =NOT(formula)

edit: and change ; with ,