VLOOKUP formula in Excel

VLOOKUP Means vertical lookup from diffrent sheet for excel column values.

Being functional or technical consultant in Oracle apps finance domain we must have good knowledge of excel as well. as most of trail balance, revenue and drill down report etc we need to tally in excel after taking dump from oracle report.

Below given is simplest formula we can use in Excel for VLOOKUP

We have two excel sheet one for supplier invoice detail and another containing supplier country details. we required vlookup kinds of formula when we have huge amount of data in doffrent diffrent sheet and we need to match or merge both sheet data into single sheet.

1. first sheet conatains supplier and invoice data

2. second sheet contains supplier country detail

3. Now we want country name against each supplier in sheet 1 from sheet 2, so we will write vlookup formula in sheet 1 as given below.

=vlookup then open bracket and click on supplier name first value i.e. "Yogesh".

4. Then click F4 3 times

in above screenshot we can see $ sign occurs before A2 after we click F4 3 times.

5. Now click on sheet 2 (this might be in another excel file as well)

6. Now select all data using mouse (here we can select entire sheet as well)

7. After selecting add one comma "," and enter number of column from selected excel column. in our case we will write 2 as we want to print country column value in sheet 1 from sheet 2.

8.  Then again enter comma "," and write false word after comma as shown in below screenshot.

9. after false kindly close bracket and press enter button it will show you match value for country against supplier name from sheet 2

10. Now drag formula present in c2 column upto c7 and you will see all matched value for country against supplier name. Value which not matched is shown as #N/A



The complete formaula in C2 as =VLOOKUP($A2,Sheet2!A1:B6,2,FALSE)