Pull the first non blank cell data

[Rajasree]

Hi,I am using an array formula to pull up the first non-blank cell data using this formula =INDEX('Raw Data'!MB2:MB1048576,MATCH(FALSE,ISBLANK(MB2:MB1048576),0)), however I need this to be add onto merged cells and its not working, Excel 2010 does not allow array formulas in a merged cell, I also have the vlookup version - (=VLOOKUP("*",'Raw Data'!MB2:MB1048576,1,), however the vloopup returns NA, whereas the Index formula returns the actual cell value. Need help

 

[baitmaster]

welcome to the board

merged cells are a pain and I'd advise you to never use them if you can possibly avoid them

that said, you could perhaps work around this by writing your array formula and merging the cells afterwards, that seems to work - not sure why, the feature seems badly designed to me