I would like to return the value in the row AFTER a lookup.
Consider B6 contains a customername, and B7 contains the customer's city. (this is a unstructured data dump where each customer has 14 rows in a record, but all the data is in column b...(eg. b1-14 is customer #1, B15-29 is customer...