I have an excel sheet with lots of rows separated in different ranges, i want to lookup "B" and return the value of the cell to its left, the table array should be based on a range that is defind in cells in column A.

see example
Capture.JPG