I am trying to get certain data out of a list that cannot be put in order. The numbers in Column A represent a Structure Number, and Colum B is the depth of a pipe coming into and leaving that structure. This is my list on sheet 1 and below on sheet 2 is where it applies.
Sheet 1
A B
1 6.89
2...
I am trying to get data from the vlookup command, but my criteria is very strict as to what I am looking for. I think I need to have the OFFSET function included, but I am not sure how.
Sheet 1
A B C D
2 2 1 (function)
3 3 2
4 4 3
2a 2a 2
2b 2b 2a
7 7 2
8 8 7
Column A or B is the number I...
