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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks