Hi Guys.

I need a bit of help with finding data from a table dependant on what is selected in a Cell.
Example, I want the following to run on a table which is determined by said cell value.
=IF(B13="",0,VLOOKUP(B13,**MATCHED TABLE**,MATCH($C$3,**MATCHED TABLE**[#Headers],0),FALSE))
Cell C4 will determine which sheet the table will be on, then the above code needs to work for that sheet.

My options for C4 will be:
Fusion,
Fusion Linear,
Biography,
Caledonia,
Caledonia In-Frame

I will have individual sheets which will have large data tables named for each.

So, if Cell C4 has "Fusion Linear" selected, The data needs to be found from that table.