The document is an expense report template and I want users to fill in a cell with the account number, then the formula fills in the account description. However, when someone hasn't filled in an account number, I want the cell to wind up blank. Here's my formula:
=VLOOKUP([@[Acct Number]],Sheet1!$A$3:$B$13,2,FALSE).
The formula connects to a separate sheet which has a list of account numbers and their account descriptions, in order to look up their account descriptions. I've tried several of the options listed in other posts on this site, but couldn't make any of them work.
Help!
TMB1234
Bookmarks