Looking up value using vlookup from Sheet2.
  • In my excel workbook there are two sheet viz; sheet2 and sheet3. In sheet2 columns are as Date, Order ID, Product, Category, Amount, Mobile and Country............ and in sheet3 columns are as same like sheet2. But in sheet3 the Country column is blank. I want to fill Country column in sheet3 according to Mobile Number by using Vlookup. I have tried this : =VLOOKUP(F2,Sheet2!$A1:$G214,6,FALSE) it showing error like #N/A. Please help.
    I am attaching the excel file snap shot.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Popular Posts of the Week