Dynamic cell value selection

Question

Hey,

I need help with my workflow, where I need to retrieve a cell value from an excel sheet.

I have 50 sheets which i import to my workflow, all xlsx files.
I need to extract a cell value in one of the sheet. The value changes in every sheet, i.e in one sheet the value might be 'ABCD', the second sheet it might be 'EFGH' and so on till 50 sheets.
Since the value changes dynamically i need to build a formula or use a tool which will help me achieve that.

If the value was the same in every sheet i could have simply used a filter tool saying( [Col] equals to "ABCD"). but since the value will be different in every sheet can't do that.
Any help on this is much appreciated

rzdodson · Answer

@Jemsheed is it a static cell reference (referencing cell A1 across 50+ sheets), or is the referenced cell changing (A1 in sheet 1, B3 in sheet 2, etc.)?

caltang · Answer

You can have a mapping table where end users can key in the value of their choice into fields (in Excel), then have your workflow read that mapping file then map it across your inputs to get your desired value.