Row of first cell with text, search from bottom

0
votes

If have texts in column A, with empty cells In B20, I 'd like to get the row number of the first non empty cell above A20, without VBA.

I found some examples with "LOOKUP" function but I get "DIV/0" error. Perharps because I have text and not numbers in column A ?

Could you help me please ?

1
excelrowmatchlookupbottom-up
What formula did you have when using lookup()? – BruceWayne
This works if I search a specific value ("Thomas") but not with "" =LOOKUP(2,1/(A1:A4=""),B1:B4). How can I get the first non empty cell please ? – John DT

1 Answers

0
votes

You can use this:

=MATCH(TRUE,INDEX(ISBLANK($A20:$A1048576),0,0),0)