I've got data in 4 different tables.

I can use vlookup and table name to find what I need:

=VLOOKUP(B3,FFTDSubjCum,18,FALSE)

but I want user to be able to select a value in validation list and then a formula to match that value to relevant table.

the array formula:

=INDEX(FFTSbj!$F$1:$F$4,MATCH(1,(C3=FFTSbj!$B$1:$B$4)*(D3=FFTSbj!$E$1:$E$4),0))

returns defined name of a table: FFTDSubjCum

How can I use it to achieve something what vlookup would do: if I put that array formula as part of vlookup it wont work:

=VLOOKUP(B3,*INDEX(FFTSbj!$F$1:$F$4,MATCH(1,(C3=FFTSbj!$B$1:$B$4)*(D3=FFTSbj!$E$1:$E$4),0))*,18,FALSE)

Thank you