VLOOKUP for Multiple Sheets

Hi - I am trying to use VLOOKUP across multiple sheets.

I have one column that is labeled clinic #, and I want to search for this clinic number across 2 different sheets, and we want to display a specific cell from that line it pulls.

I have no problem doing a VLOOKUP for one of the sheets, I am running into an issue when trying to check the second sheet.

The current VLOOKUP formula I use for the single sheet is =VLOOKUP([Internal #]@row, {Electric Range 1}, 17, false)

Answers

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    First I would recommend INDEX/MATCH as a formula because it is much easier. Then you can add columns, or remove columns, or move columns in your source sheet and it will not matter.

    Second, best practice is to name your ranges. So that way when you are having to troubleshoot a formula, or explain one six months later, you don't have to open every single one. So in this instance it would be INDEX({Electric - Named Range}, MATCH([Internal #]@row, {Electric - Clinic #},0)).

    Now comes the tricky part - to pull two INDEX/MATCH formulas into one cell. I would need more info on what you are trying to pull in. Would it be possible to use an IF statement, or a JOIN or COLLECT formula?

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!