Hi team,
I was wondering if someone can help me with an interesting lookup issue I am having. I will receive a file that will be similar to Tab 2, out of which I need to build a view similar to Tab 1 below (I have manually filled in the numbers, to show what those cells should read). I tried using INDEX/MATCH but am having difficulties due to the way Tab 2 is delivered. Can someone please help? Thank you.
TAB 1
TAB 2
I was wondering if someone can help me with an interesting lookup issue I am having. I will receive a file that will be similar to Tab 2, out of which I need to build a view similar to Tab 1 below (I have manually filled in the numbers, to show what those cells should read). I tried using INDEX/MATCH but am having difficulties due to the way Tab 2 is delivered. Can someone please help? Thank you.
TAB 1

TAB 2

Last edited: