lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
I'm close but I can't figure this last bit out.
=INDEX(INDIRECT(B4&"!G:G"),MATCH(C4,INDIRECT(B4&"!C:C"),0))
Column B is the tab name of the tab I am trying to reference with the formula. If I evaluate formula the indirect combines the tab name in column B with !G:G but they seem to be surrounded by " instead of ' whci looks like what's causing #REF. The Index match works, I just can't get the INDIRECT to let me alter the reference tab correctly.
=INDEX(INDIRECT(B4&"!G:G"),MATCH(C4,INDIRECT(B4&"!C:C"),0))
Column B is the tab name of the tab I am trying to reference with the formula. If I evaluate formula the indirect combines the tab name in column B with !G:G but they seem to be surrounded by " instead of ' whci looks like what's causing #REF. The Index match works, I just can't get the INDIRECT to let me alter the reference tab correctly.