Index and Match - Referencing a different sheet

celento ✭✭✭
edited 12/09/19 in Formulas and Functions

Is it possible to do an Index and Match referencing another sheet? My formula works when I am using data on the same sheet but when I try to reference a different sheet it does not work.  


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Yes it does.

    If you post your formula, we might be able to tell you why it isn't working.

    Are you getting an error message?


  • celento
    celento ✭✭✭

    Here is my forumula:

    =VLOOKUP(1, {2Testing_WFO (BO)_Master Sheet Range 1}, 2, false)

    I am looking up the value of "1" in column A. If it finds "1" then return the value of the column B. The result I am getting is it display the correct value in B but it just repeats that value. 

    In the sheet I am referencing I have selected my range.

    Thank you!


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    By 'repeating the value' do you mean you copy the formula to the rest of your column?

    If so, the first argument (1) is what you are searching for. It will always find the same value from column B because you are always looking for the same thing.

    You want to replace the 1 with something that is unique on each row (and needs to match in the source sheet)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!