vlookup, indirect and match from multiple tables

Hi

I'm trying to solve this problem and I'm stumped so any help would be greatly appreciated

I've got 6 sheets to lookup values from, Voryl 30, Voryl 35, Voryl 40, Runtyl 30, Runtyl 35 and Runtyl 40 where I've also defined named ranges with the same name but no space.
I've got another variable for delta t which is also Data Validation list of three values i.e. 30, 35 or 40°C.

Example, Voryl40 table, all Voryl tables have the same first column and the same two first rows:

\1


On the sheet I want the values from these tables I use Data Verification and list to select between 2 main types, another to select the subtype/height and the third to select the desired length.

\1
(Starts at Column B)

In column F is the formula which the value from the right table is to be displayed which is 210 in this example, but I'm getting either #REF or #NAME or #VALUE as a result to my tinkering.

Here's the vlookup formula which I'm trying to use but isn't working (#VALUE):

=VLOOKUP(E11;INDIRECT(D11&deltat);MATCH(F11;D11&deltat&"'!B2:S2";0);FALSE)

Using evaluate shows that the first part works but not when I'm trying to match the right column:

\1

Any ideas? I've also tried to use index, match but with the same result.

Hi BB1972

Point taken

I did resolve this with a little help, here's the formula that did the trick:

Please Login or Register  to view this content.

Cheers