I'm fairly new to excel, at least for using it more than just cataloguing my CD collection.
I'm using a VLOOKUP function to find a name in another worksheet, and then provide the zip code from that worksheet. The problem for me is that the cells are formatted as zip codes and the zip codes are from the east coast which means they start with 0. When I complete the function I only get the last 4 digits of the zip code. Can anybody help me? A similar problem happens when I try to VLOOK for their birthdate, some strange numbers come over. Thanks for any help, and if I shouldn't be wasting you power users' time, please let me know that too. Thanks! Dev
I'm using a VLOOKUP function to find a name in another worksheet, and then provide the zip code from that worksheet. The problem for me is that the cells are formatted as zip codes and the zip codes are from the east coast which means they start with 0. When I complete the function I only get the last 4 digits of the zip code. Can anybody help me? A similar problem happens when I try to VLOOK for their birthdate, some strange numbers come over. Thanks for any help, and if I shouldn't be wasting you power users' time, please let me know that too. Thanks! Dev