Solved: Lookup help - Page 2

Ben_Rix · 12-01-2020 05:44 AM

Im sorry to waste time on here with such a basic request, but, I am having an issue with my lookup. I have read and re-read all the docs, and I cant see where I am going wrong.

This is my formula:

LOOKUP([Location], “Clinic Address”, “Location”, “Address”)

In my head, [Location] is the find value, “Clinic Address” is the table to find the address, “Location” Column to match, “Address” To return the value.

Now, the address table has 5 addresses in and it will only return 1 no matter on which location I choose. Would someone please be able to point me in the right direction.

Thanks a lot,
Ben

Rafael_ANEIC-PY

Hi @Ben_Rix , if the column where you wish to apply this formula is not the same table as “Clinic Address” you need to use [_THISROW] as stated in the documentation:

So you could try using LOOKUP([_THISROW].[Location], “Clinic Address”, “Location”, “Address”)

If that’s not the case, could you please provide some sample screenshots of how your tables look like?

View solution in original post