Vlookup on iPad sometimes works sometimes doesn’t work

Hello,

I have a simple HLOOKUP formula for finding the next day of the week.

The formulas are entered across the first row beginning at cell B1. When I enter a day in cell A1, then the week populates as shown:

[ATTACH]626809[/ATTACH

However, when I change the date in cell A1, some formulas don’t work:

34A08EB6-5CF3-426E-87D0-6D2E14E564FC.jpeg

I’m at a loss as different days of the week result in different outcomes:

5BB3421C-772B-4143-B914-BE736EC844B3.jpeg

I also tried this as a VLOOKUP and had the same problem. Any help would great, thanks.
Maria

Sorry, my pictures would not post in the correct order.

I don’t know how to attach It. But I did forget to say that I’m having this problem on my iPad.

Originally Posted by AliGW

Attach the workbook. We can't troubleshoot pictures.

Most likely issue will be leading or trailing spaces in either the lookup cell or the array.

I checked for trailing spaces and everything looks good. I’m sorry I can’t figure out how to attach. I tried uploading it where it says “manage Attachments”. But the paper clip icon doesn’t work. Obviously, I am doing something wrong.