tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I need to do an index match type lookup, but the column I'm doing the matching down changes according to the number
So instead of "=INDEX('Item ID'!A:A,MATCH(B3,'Item ID'!D:D,0))" the 'Item ID'!D:D, the column is determined by the number in column E so if E3 = 6 it would be Column F
any ideas how to do this?
I need to do an index match type lookup, but the column I'm doing the matching down changes according to the number
So instead of "=INDEX('Item ID'!A:A,MATCH(B3,'Item ID'!D:D,0))" the 'Item ID'!D:D, the column is determined by the number in column E so if E3 = 6 it would be Column F
any ideas how to do this?