guamlenahans
Board Regular
- Joined
- Oct 25, 2006
- Messages
- 113
Hello,
I have a sheet title "20K Vol" that measure how much liquid is in a container in 1/8 inch increments. On the sheet, there are two columns that repeat over and over. Column A is "inches" and Column B is "gallons. This repeats in C/D, E/F and so on.
My question is, since this in not in one long list in two columns, how do I do a lookup? My desired end state, is on a separate sheet inside the same workbook, when I type in a inch value in column A I will get the result from the 20K Vol sheet in column B.
Thanks
Rob
I have a sheet title "20K Vol" that measure how much liquid is in a container in 1/8 inch increments. On the sheet, there are two columns that repeat over and over. Column A is "inches" and Column B is "gallons. This repeats in C/D, E/F and so on.
My question is, since this in not in one long list in two columns, how do I do a lookup? My desired end state, is on a separate sheet inside the same workbook, when I type in a inch value in column A I will get the result from the 20K Vol sheet in column B.
Thanks
Rob