1st worksheet;
fill in form cell A1= inches_____
cell A2=gallons_____

2nd worksheet=lookup sheet

Column A= inches
Column B = gallons

the inches column goes from 1 - 98 down 2 pages with headings on both pages,
I need 1st worksheet to lookup the inches entered and fill in the gallons
from the 2nd worksheet.

this happens in 6 locations on the 1st. worksheet, I can modify the initial
solution for the other locations, just need help getting the 1st. lookup
going.

Thanks in advance, David