Hi,
I'm trying to use an index match and the column where I'm trying to return data has blank cells in it. The formula I tried but didn't work was:
=INDEX(F2:F2000,IF(F2:F2000<>"",MATCH,A1,A2:A2000,0)))
The problem I'm running into is that the data I'm trying to return on an entry occurs after a blank and that entire entry is skipped. Below is an example so you can see what's causing my issue.
order A return data
order A blank
order B blank
order B return data
order B return data
So order A will allow to me return the information I'm trying to grab for that order but on B because it's first cell is blank all of order B is skipped and I can't return that piece of data I'm trying to get.
thanks for the help.
Bookmarks