Lookup across multiple columns in a dataset to return a value

[Trillum]

Hi
I have a dataset that runs across multiple columns that shows all the same type of data. I need to find a policy # within that dataset and then return values that are in static columns at the end.
I can't seem to figure out the right combination of V/H/Xlookups, find, index, match that will move through the entire dataset as I don't know which column the value might be in.
I'm sure it's a simple fix....

I'm posting from a work computer so I can't download the XL2BB file, sorry.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=INDEX($O$2:$O$100,AGGREGATE(15,6,(ROW($O$2:$O$100)-ROW($O$2)+1)/($A$2:$M$100=Q2),1))

 

[Trillum]

OMG aggregate! I didn't think to use that!
THANK YOU!!!!!

 

[Fluff]

You're welcome & thanks for the feedback.