I want to use vlookup function in two different table in same time
T Toppers May 21, 2007 #2 An example of what you want? =VLOOKUP(VLOOKUP(A1,Sheet2!A:B,2),Sheet3!A,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?
An example of what you want? =VLOOKUP(VLOOKUP(A1,Sheet2!A:B,2),Sheet3!A,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?