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.

  • 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.

    Great suggestions dude Me also try this.


    Student deals

  • If you're filling in an order form in Excel, you can use the VLOOKUP function to find the selling price for each item in the sales order. For example, in the screen shot below, the order form is on the Orders worksheet, and a VLOOKUP formula in column D pulls the cost from a pricing table on the Prices worksheet.


    Regard,

    Professional Wikipedia Editors