I wonder if someone could help me fixing this issue
Planning to have nearly 100 columns to be viewable without scrolling horizontally, so each column shoud have 21 pixels's width, so it's for this reason I can't nor enlarge the columns neither merge themm...
I need that text in A2 overflow/overwrite over E2, F3, G3, H3 cells which are blank since the validation data in E3 is not selected
I want that A2 reacts exactly as I2 is doing by overwrites blank cells in front of it (M2...)
Could you help me fix this out? Any advice would be appreciated.
I share with you an example of my work
update:
={"";IFNA(VLOOKUP($E$5,Sheet2!$A$2:$E$5,5,FALSE))}