SOLVED IF Function Question maybe -Autofilling account numbers to...

Jeff, thank you so much. I actually got it to work, although it seems to be cap sensitive/font sensitive (I also triple checked my spelling to make sure the account names in both documents were an exact match). The formula only seems to work if I go into my "Account Names" worksheet and copy and paste the account name into my other worksheet. Even when I use the same exact font, type size as the "Account Names" worksheet, it still doesn't work, it has to be copy and pasted. I have attached the two documents, if you'd like to take a look. Perhaps, I should just start each document over, using the same font, size, capsize. Or perhaps, there is some kind of hidden setting that I need to turn off/turn on. Thanks again.

First, your file "Display Bookings....xlsx" has VLOOKUP formulas that refer to a different file, which you did not attach. So I can't verify what you did.

Second, in the list of account numbers in both files that you did provide, almost all of the account names have spaces at the end. Those will not match a version that does not have spaces. That's why it works when you copy and paste, because your paste includes the spaces. You need to get rid of those spaces. See attached.

VLOOKUP is not case-sensitive and there is no built-in Excel function that cares about bold, font, or any other formatting aspect.

I would have never figured that out. The trimmed version worked perfectly. Thanks so so much.