how do i use vlookup function in more than one table same time

T

Toppers

An example of what you want?

=VLOOKUP(VLOOKUP(A1,Sheet2!A:B,2),Sheet3!A:D,4,0)

This will lookup the value in Column B of Sheet2 corresponding to A1 and use
this value to retrieve the value from column D of Sheet3.

Is this is what you require?
 
Top