Hello everyone,

I have a table set up for which is use the below code to retrieve data,
depending on the info I insert:

=INDEX(F3:H22,MATCH(B8,E3:E22,0),MATCH(B2,F2:H2,0) )

This works a treat, however, I want to use more than one table for the data
retrieval. ie: cell A1 will have a choice of the user inserting 1,2 or 3
for selection of the 3 tables I have created that will range J2:M22 &
O2:R22, whilst B2 & B8 dictate the row and column required for all. The
column and rows of all three tables will be the same so this can be achieved
ie: A,B,C going across and 1 through 20 going down.

Does this make sense? I hope so. I am fairly new to indexes etc.

Thanks again in advance.

Aaron