Help IfBlank use data from next cell
You're Welcome!
"quzie" wrote:
Thanks for the quick responsed. It worked perfectly. I just had to add in the
reference to the sheet. Thanks so much!
=INDEX(qryGraphExportStep4!K2:qryGraphExportStep4! K12,MATCH(TRUE,INDEX(qryGraphExportStep4!K2:qryGra phExportStep4!K12<"",),))
"Teethless mama" wrote:
=INDEX(K2:K12,MATCH(TRUE,INDEX(K2:K12<"",),))
"quzie" wrote:
I am using the data in one of my colums as the input for a subtitle on
another spreadsheet. So I have
=IF(ISBLANK(qryGraphExportStep4!K2),qryGraphExport Step4!K3,qryGraphExportStep4!K2), which works fine unless K3 happens to contain no data.
My problem is if K3 is blank I want it to move down to K4 and pull that data
and if K4 is blank down to K5 and pull that data, etc until K12.
Any assistance would be appreciated, I am not very experienced with excel
|