Which formula to use?

01/14/22
Accepted

Best Answer

  • Mike WildayMike Wilday ✭✭✭✭✭
    Accepted 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 WildayMike Wilday ✭✭✭✭✭

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

  • Mike WildayMike Wilday ✭✭✭✭✭
    Accepted 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 WildayMike 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 WildayMike 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.

Sign In or Register to comment.