Excel Table and Vlookup

[JeannetteE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]SubCat
[/TD]
[TD]Service
[/TD]
[TD]Category
[/TD]
[TD]Subcateory
[/TD]
[TD]Subcategory Description
[/TD]
[TD]Incident Type
[/TD]
[/TR]
[TR]
[TD]tbl3rdPartyAcces
[/TD]
[TD]Access Management
[/TD]
[TD]3rd Party Access
[/TD]
[TD]Disable 3rd party access
[/TD]
[TD] =VLOOKUP([@Subcategory][@SubCat],2,FALSE)
[/TD]
[TD]=VLOOKUP([@Subcategory][@SubCat]3,FALSE)
[/TD]
[/TR]
[TR]
[TD]tblDeviceEncryption
[/TD]
[TD]Access Management
[/TD]
[TD]Device Encryption
[/TD]
[TD]FastPass guidance
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!