How to get vlookup to not lookup search value is blank
I have several sheets that link together. The Client Profile is the "master sheet" were 85% of data is contained. As a new client is added, a client # is assigned to that person. Then on the next sheet - the Account Profile sheet, we enter the assigned client # and I have a simple Vlookup.
We ran across an issue were a client was entered on the Client Profile but no Client # was assigned - should be rare but it might happened. On the Account Profile, it started to pull that clients information into any row that had a Client # that was blank.
Screenshot of Client Profile that has Client number assigned
Screenshot of formula
Because Client #2 is blank - it kept pulling the one client profile that was not assigned a client #. What can I add to my vlookup that says if Client #2 or Entity #2 is blank, don't do the lookup?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!