Hi All,
My name is Wassim and I am new to the forum. I always found help that I needed by browsing the web, but I am at a dead end right now. I would very much appreciate the help of you experts:
I have a pretty complicated framework, so I will to try to only post the part, where the error is occurring.
=INDEX(HLOOKUP($C$8,H2:MT6,5,0)&3&":"&HLOOKUP($D$8,H2:MT6,5,0)&3,MATCH....
Apparently it is not possible to get the columns of a range through an Hlookup if I add the whole "&" part to it (it ends up being "H3:Z3", I think those apostrophes are the problem making it a text?).
Can you help?
Thank you!
Bookmarks