Excel Table and Vlookup

[JeannetteE]

SubCat	Service	Category	Subcateory	Subcategory Description	Incident Type
tbl3rdPartyAcces	Access Management	3rd Party Access	Disable 3rd party access	=VLOOKUP([@Subcategory][@SubCat],2,FALSE)	=VLOOKUP([@Subcategory][@SubCat]3,FALSE)
tblDeviceEncryption	Access Management	Device Encryption	FastPass guidance

<tbody>
</tbody>

Hi,

I have a table as above. I want to populate the last 2 columns with information from a Table with the name in the first column, but because this table name will be different for each Row I can't just add the table name in the formula. How ever it is not bringing back the information unless I Add the table name in the formula.

Any help please

 

[Eric W]

Try:

=VLOOKUP([@Subcategory],INDIRECT([@SubCat]),2,FALSE)

 

[JeannetteE]

Try:

=VLOOKUP([@Subcategory],INDIRECT([@SubCat]),2,FALSE)

Thank you so much!

 

[Eric W]

You're welcome!