Match cell contents with a table name

[antmol89]

Hi guys

Is it possible to use VBA to achieve the following:

• Determine if cell "A1" on Worksheet1! = the name of a table on Worksheet2!
• If it does, perform an INDEX in Column 2 and MATCH in Column 3 of that table

I basically want the code to perform something like this:

• IF A1 = A table name on the Worksheet2, then go to that table and INDEX(Column 2,Match(A2, Column 3)

Really struggling on this one!