Hi Everyone,
Long time lurker and reader here. I'm working in healthcare and needed help with a lookup function. I tried searching on google and youtube for tutorials but couldn't find quite exactly what I need.
help pic.png
I'm trying to create a formula for cells E9 to F11. Essentially I want to lookup the codes in D9 to D11, which may be in any one of the Code1 to Code4 columns (4 columns), I then I want to return the TicketID and Date.
I don't know how to search in multiple columns like this. Can someone please help point me in the right direction?
thank you kindly,
Bookmarks