I have 4 Tables with failure cause code data in them. The Table names are: Hydro_CC, CC_CC, CT_CC, Fossil_CC. I want to perform a vlookup in the appropriate table based on values in previous column.
I have a sample spreadsheet.
For example in the first row I want to vlooup for 1000 in Table Hydro_CC to find the appropriate value, based 1000 in the first column and Hydro in the second column.
In the second row I want to vlookup for 1020 in the Table CC_CC to find the appropriate value based on the 1020 in the first column and the CC in the second column
My attempt is:
=VLOOKUP([@[cause code]],[@[plant type]]&"_CC",6,0)
where @[plant type]]&"_CC" is try to take the value in the second column and put it together with "_CC" to come up witht he Table name.
Can you help with the formatting or suggest alternate functions?
Hi John
See attachment.
I have created 4 tables and gave each a name as per your plant type.
I then use the INDIRECT function to refer to them.
Hope this helps.
Sunny
