I need help comparing two columns on two different workbooks

[Jiggs24]

Here is what Im trying to achieve... I have workbookA and workbookB. I am trying to compare column A of workbookA with column E of workbookB. I need to find duplicates between the two and have them output to column B of workbookA if found. Help me please!!

[FDibbins]

Hi and welcome to the forum

You dont need VBA for this, a simple vlookup will give you what you want.
Create the vlookup as if it was inteh same workbook, pointing to the other workbook as if it were just another sheet

[Jiggs24]

Thanks, I was attempting this with vLookup but was a bit confused on how to do this

[FDibbins]

So, did you figure it out? It's really makes no different if the vlookup() is on the same sheet or a different sheet or a different WB. Let me know if you need further assistance?

[Jiggs24]

lol I wish Im kinda green with excel all together so vLookups are even intimidating to me. I can try and figure it out.

[FDibbins]

OK see if this helps.

Assume this is in sampleworkbook(1) sheet1....

	A	B
1	1	0-50
2	7	50-100
3	2	100-150
4	3	150-200
5	4	200-250
6	5	250-300
7	6	300+

And then in SampleWorkbook (2) you have this...

	A	B
1	1	0-50
2	2	100-150
3	3	150-200
4	4	200-250
5	5	250-300
6	6	300+
7	7	50-100

B2, copied down=VLOOKUP(A1,'[SampleWorkbook(1).xlsx]Sheet1'!A$1:B$7,2,0)