Using CONCAT to compile a field name which then pulls in that data

[Dusty_H]

I'm trying to use CONCAT to pull together multiple drop down sections into a Field name in order to look up a price.  Have any of you been able to use CONCAT to generate a calculated field that will then display a different Form Field?  

Example

CONCAT("{DE:",{DE:Tier},"-",{DE:Level},"}")

Creates: {DE:Tier2-Level3}

Which would then pull data from that Form Field

Tier2-Level3 = $23

So far i haven't been able to make this to work.

I seem to be able to do this if i create a calculated field that is just the name and then another calculated field that uses the IF function.  However I would have to create an IF calculation with 56 variants.  I'm hoping there is a way to do this simply in a field using CONCAT or another expression that would then just generate the Field name and it then reflects that value.

[VictoriaLinn · Accepted solution]

Hi @Dusty_H - I think you would have to do an IF calculation in this case to mirror an Excel VLOOKUP. You need that additional layer of the IF statement to tell the system the criteria to populate the pricing information. The CONCAT formula isn't smart enough to know and is just the combination of data. Definitely agree that it is tedious work though!

[Dusty_H]

Thanks.  I was hoping there would be a simpler way but from all that i can tell I think the IF calculation is correct.  Maybe someday there will be an easier way to do lookups like this in Workfront.