Buzz
In cell F3 of the Consolidated sheet, enter the formula =Vlookup(D3,
While keeping the entered formula unchanged, navigate to the Unit Price sheet and select the condition price range A2: B5. Press F4 to lock the cell references. The formula will become: =Vlookup(D3,'Unit Price'!$A$2:$B$5
In the existing formula, add the following: ',2, TRUE)' and then press the Enter key.
Now, drag the formula down to the remaining cells in the column to display all the results:
Apply Vlookup function between two files
With the same requirement but data located in different files instead of sheets, how would you input the formula?
Step 1: Open both Excel files.
Step 2: In cell F3 of the Revenue file, enter a formula similar to the one used for the two sheets: =Vlookup(D3,
Step 3: Switch to the Unit Price file, select data range A2: B5 = > click F4 to lock the A2:B5 range.
Step 4: Return to the Consolidated file, continue the formula input: ',2,TRUE)' and press Enter.
Step 5: Perform the formula copy to display the entire results in the remaining cells in the column.
Above, Software Tips has guided how to use Vlookup function between 2 files and 2 sheets in Excel, hoping it will be helpful for you. Wish you an efficient working day!
