Vlookup not working for two sheets in same workbook

  • Hi,


    I am trying to include vlookup function in sheet2 (cells: B2,B3,B5) to look up values in sheet 1 (File is attached herewith).


    When two sheets are created in two workbooks, the mentioned vlookup function works correctly. But when sheets are get to one workbook, lookup function does not return the correct value.


    Highly appreciate if someone could help.


    Many thanks!

  • Hi again. The issue was sorted. Please ignore above request.


    What has happened was when I change from sheet to sheet (while writing the formula), the sheet mentioned in the formula is auto changed by the computer. I noticed it lately. When i change the sheet name in the formula manually , vlookup works correctly.