• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Excel VLOOKUP Question

K

kaiweiler

Limp Gawd
Joined
Dec 19, 2007
Messages
314
Hey guys, I am trying to make a point of sales software system using Excel and it requires a search-able customer database.
The business does buys and loans, both of which require the customer's ID information. I want to be able to input a customers name and have it bring up their ID number and ID type (pulled from the customers tab).
I have gotten this figured out using VLOOKUP, but my problem is that if there are two "Smith, John" in the database, it will automatically just use the first in the list and not give any indication that another is available.
Is there any way to it to indicate when this happens, or offer an alternate method of inputting the customers info?
 
You must log in or register to reply here.
Back
Top