HLOOKUP for first value not blank?
I've tackled this a few ways already but everything comes back with errors. Here's the latest -
=INDEX([T1 BI Blend Options]1:[T1 Data Recon Options]1, MATCH(false, ISBLANK([T1 BI Blend Options]1:[T1 Data Recon Options]1), 0))
Does 'ISBLANK' come back with a value different than false? I tried using the ISBLANK formula standalone but it seems to require being nested in another formula.
If I need to use NOT(ISBLANK how do I tell match that's what I want to pull?
Background: Of the subsequent 15 columns, I want to pull the value that is populated in that row. Below is an example of what I did in excel; I'm exploring if I can replicate in SS.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!