VLOOKUP comparing two excel table in different sheet

[remar]

Hi, i am going to compare two different data in different sheet i am confused of volookup how do this work. please help thanks.

[FDibbins]

You would do it the exact same way as if the 2 tables were on the same sheet. If you upload a sample

Sheet3...

	A	B
1	1	a
2	2	b
3	3	c
4	4	d

Sheet2...

	A	B
1	1	a

B1=VLOOKUP(A1,Sheet3!$A$1:$B$4,2,0)