Which formula to use?

HardWork

Mike Wilday

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

Mike Wilday

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

Mike Wilday

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

HardWork

So would it be something like:

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

?????

HardWork

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

HardWork

It works amazing!!!! Thank you

Mike Wilday

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

HardWork

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

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.