Hi all,

I'm struggling to solve the following, struggle a bit and would be glad for your help:




I've got a Table with data as below (sorry. not allowed to post links or pictures or attachements):

ID | ... | Cat 1 Name | Cat 1 Value | Cat 2 Name | Cat 2 Value | ... | Cat 10 Name | Cat 10 Value
...
Objective:
  • Lookup from a table
  • For a given ID (from a fixed column) and determine Row
  • Look up from cultiple Categories (Cat1 to Cat10) the Value where the Name matches "Money in $"

I know how to get the value for a given row with INDEX and MATCH:
=INDEX(A2:40;J4;MATCH("Money in $";A2:J4;0)+1)
How can I make this happen (ideally in one expression without helper cells) to Make that expression finf the right row machtig an ID e.g. 12345 and does the Match-Category on that row?

Thanks a lot in advance