I have several worksheets containing similar (but not identical, as some
tables have more rows than others) tables of data. These worksheets are named
for different vehicle types (petrol, diesel, petrol SUV, diesel SUV etc.).
Each table contains information pertaining to different vehicle types, with
the first row listing various engine sizes (2000, 2500 etc.).
As part of a larger operation, I want users to select a vehicle-type from a
drop-down list on my main 'search' page and also enter their engine size. The
selected values will determine on which worksheet a lookup function performs
and for which row of that particular table the function will 'look'. The
function will then return the value in the relative column.

E.G.
A user selects 'petrol SUV' from the drop-down list and enters '2700' as
their vehicle's engine size. A vlookup function then looks at the table on
the worksheet 'petrol_SUV' and returns a value from the required column in
the same row as '3000' (next size up from the size the user entered).

I had tried using INDIRECT with VLOOKUP to get to the correct sheet but then
I'm stuck with accessing the correct row (which is determined by engine
size), from which to offset to the required column.

Another post provided part of the answer, which I thought I could combine,
but now I'm stuck again.Any help greatly appreciated.

Additionally, I'm unsure how to select the various possible tables (on each
worksheet) as they have the same structure, but differing numbers of rows
(petrol vehicles have more engine types than diesel vehicles).

Hope this makes sense and thanks in advance for any assistance.