I need help with the vlookup functions in excel. Let's say I have two tabs, the second tab is a pivot table based on the first tab. I want to build a vlookup function (probably need two in the same formula) to pick up a field in a particular column based on the vlookup function. This should be a vlookup within a vlookup? Here’s what I want, in tab B (the pivot) lookup a value in tab A, then once it finds that number (there’s a list of the same number) then go back to tab B (select another field) then lookup on tab A again then return one of the field. Kinda difficult to explain, Assume that in tab A, I have C B A X 1 2 4 X F E D X And in tab B, I have A, B, C, D, E, F 1 2 3 4 5 6 The first lookup is, in Column A’s number lookup on column B, I know the return value is 100% true because the pivot is based on tab A. Then after that vlookup finish, then go to the next one, lookup Column D to tab A in column A. When both of those criteria hit, then return column X to tab B

I'm not sure if this is what you are looking for, but here goes... =VLOOKUP(VLOOKUP(F1,Sheet1!A1:C10,3,0),A1:B10,2,0) This formula, placed in Sheet2, will: - Read the value in Sheet2!F1 - Lookup that value in Sheet1!A1:A10 - Return the corresponding value from Sheet1!C1:C10 - Lookup the returned value in Sheet2!A1:A10 - Return the corresponding value from Sheet2!B1:B10