Good day, I am having some trouble with the lookup function.
Let me explain a bit more. I have a form that allows the user to enter data, the criteria I want the lookup to take into account is called “Diagnosis”. Then below that I have an Image field that should display an image based on the "Diagnosis performed. The “Diagnosis” field is a list that the app gets from the same sheet as where the image is.
I get expression valid but nothing is displayed.
=LOOKUP([Diagnosis], “Diagnosis and Treatment”, “Diagnosis”, “Standard Treatment Guide”)
The first [Diagnosis] is the form selection, correct? Then “Diagnosis and Treatment” is the sheet name where the Diagnosis list comes from as well as where the images are kept. Then the last “Diagnosis” in my expression refers back to the list?
And lastly the “Standard Treatment Guide” refers to the column name where the images are.
Did I make a mistake somewhere?