Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
I have complete function disfunction
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...- aresar
- Thread
- Replies: 2
- Forum: -Engineering spreadsheets
-
excel vlookup and offset
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...- aresar
- Thread
- Replies: 3
- Forum: -Engineering spreadsheets
