Which formula to use?

Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    =VLOOKUP( [Facility Name]@row, lookup_table, 2, false)

    You'll need to click on the cross-sheet reference when you get to the lookup table part and select both columns in your lookup sheet.

    Let me know if you have any questions.

Answers

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Vlookup would work great for your needs! But you could use other methods as well.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    =VLOOKUP( [Facility Name]@row, lookup_table, 2, false)

    You'll need to click on the cross-sheet reference when you get to the lookup table part and select both columns in your lookup sheet.

    Let me know if you have any questions.

  • So would it be something like:

    =IF([Facility Name]=VLOOKUP{sheet 2 details with facility names}=VLOOKUP{sheet 2 details with address}

    ?????

  • oh so I select both columns on sheet two at one time. I was doing it seperate.

  • It works amazing!!!! Thank you

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Awesome, yes you select both columns in the Vlookup. I'm glad you got it working! 👍️

  • Hi Mike,

    Is there another way I can pull contact information from another sheet based off parameters defined @row level. So that when a ticket is entered in based off the Facility the appropriate POC details populate in the SS?

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    There are other formulas that can be used. A combination of Index/Match can be used. The method is nice because it doesn't depend on your items being in any particular order. I've never mastered it but you can do some searching for index match in the community and see what comes up.