Try:

=IF(B1="","",VLOOKUP(B1,Sheet2!A1:B98,2,0))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"David D" wrote in message
...
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