Dynamic table reference

[karldugan]

Hello all,

=INDEX(LBA[#All],2,2)

I have the above formula but what I need is the reference to the table to be dynamic based on criteria in column H.

I've tried using INDIRECT but it seems to just be throwing up #REF error.

Thanks in advance for any help.

Karl.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You would also need to give us more details/sample data (XL2BB) as your description so far is extremely vague.