Matching 2 datas (vlookup?)

[Gotchaman]

I have to compare records from 2 different database. Examples below. I need to compare them based on barcode and see if their locations are different from database 2. If they match, then it says "Yes." If not, it returns the location from the db2. If it cannot find a barcode in the database 2, then it should return a value something like "not found." How do I do this?

Excel Workbook
	A	B	C	D	E	F
1	Database 1				Database 2
2	Bar Code	Location			Bar Code	Location
3	090001141131	101A018			090001141131	101A018
4	017025743001	101A024			017025743001	101A024
5	017033021001	101A040			017033021001	101A040
6	017069637001	101A093			011000346001	115B006
7	017189535401	101B002			011000407001	115D116
8	018622294001	101C046			011000822001	107H062
...

The output should look something like this:

Excel Workbook
	A	B	C	D	E	F	G
1	Database 1					Database 2
2	Bar Code	Location	Match?			Bar Code	Location
3	090001141131	101A018	Yes			090001141131	101A018
4	017025743001	101A024	Yes			017025743001	101A024
5	017033021001	101A040	Yes			017033021001	101A040
6	017069637001	101A093	115B006			011000346001	115B006
7	017189535401	101B002	115D116			011000407001	115D116
8	018622294001	101C046	Not found			011000822001	107H062
...

 

[adam087]

Try

Excel Workbook
	A	B	C	D	E	F	G	H
1	1	Database 1					Database 2
2	2	Bar Code	Location	Match?			Bar Code	Location
3	3	90001141131	101A018	Yes			90001141131	101A018
4	4	17025743001	101A024	Yes			17025743001	101A024
5	5	17033021001	101A040	Yes			17033021001	101A040
6	6	17069637001	101A093	115B006			11000346001	115B006
7	7	17189535401	101B002	115D116			11000407001	115D116
8	8	18622294001	101C046	Not found			11000822001	107H062
9							17069637001	115B006
10							17189535401	115D116
Sheet1

Excel 2002

Cell Formulas
Range	Formula
D3	=iferror(IF(VLOOKUP(B3, $G$3:$H$19, 2, FALSE)=C3, "Yes", VLOOKUP(B3, $G$3:$H$19, 2, FALSE)), "Not found")

 

[Gotchaman]

Thanks but I'm getting an error. It has something to do with $G$3:$H$19 part.

 

[Gotchaman]

anyone?

 

[Terrym76]

Try this in D3

=if(ISERROR(VLOOKUP(B3,$G$3:$H$19,2,0)),”Not Found”,IF(VLOOKUP(B3,$G$3:$H$19,2,0)=C3,”Match”, VLOOKUP(B3,$G$3:$H$19,2,0)))

 

[Gotchaman]

Terrym76, it returns "#NAME?"

 

[Aladin Akyurek]

C3, control+shift+enter, not just enter, and copy down:

=IF(ISNUMBER(MATCH(B3,IF($E$3:$E$8=A3,$F$3:$F$8),0)),"Yes",
    VLOOKUP(A3,$E$3:$F$8,2,0))

 

[Terrym76]

Try this in C3, was referencing the other reply.
=IF(ISERROR(VLOOKUP(A3,$E$3:$F$8,2,0)),"Not Found",IF(VLOOKUP(A3,$E$3:$F$8,2,0)=B3,"Match",VLOOKUP(A3,$E$3:$F$8,2,0)))

 

[Gotchaman]

Thank you. That worked.