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