Building a doc for a Pharmacy: Single cell to lookup if record exists and if it doesn't exist allow me to enter it

Sadly, I’ve got a new issue, I’ve done a new community post, here in case anyone that’s following this thread might be able to help out?

Thanks in advance for any thoughts!