Finding 1st Occurrence

I have a list of names in column A1:A20. Within that list , there are names called "Blank". There may be up to 4 of these. In Column E1:E4 I have E1="", E2="B", E3="C" and E4="". This could change.
I need a formula to return the first non-blank letter (B), which is in E2 in Column B next to the first instance of the name "Blank". Then the next non-blank letter (C), which is in E3 next to the second instance of the name "Blank" in Column B.

Is this possible?

Thank you in advance for any help you can provide.

Hi. Before we get going on this one...

1. Is your forum profile showing the Excel version that you need this request to work with?

The best solutions often rely on knowing WHICH version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.

2. Please amend your profile to show your approximate (e.g. national) location.

3. A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

If there are no macros in your file, please upload an XLSX, not an XLSM.

Thanks. Please amend your profile to show that.