okay im mainly a database guy so im finding some excel quirks..here is an annoying one for me..
I export from one dbase into excel so that some people in my dept. can use them for whatever purposes they need. (its 1 workbook with 5 sheets)
now the problem is a little complicated to explain. But I use a few "VLOOKUP"'s to fill in data for them in the spreadsheets..this works great if the vlookups occur on fields where the data is in there from the export from the database..if it is not it does not work because of a formatting issue. heres an example:
I use vlookup up the the policy# field it works fine if the policy# field is filled in from the dbase export. If it is not you cannot manually enter the policy number you have to copy it from somewhere else ont he page that has exported the policy number and then paste it into the field your trying to add!
Ive checked the formatting..they are all consistent so I have no idea why it matters..but it does..
if anyone understood what I was talking about and can give me any clues please let me know..this one just doesnt make any sense..
and thanks to all who have answered by previous 2 posts i appreciate it
-Ins
I export from one dbase into excel so that some people in my dept. can use them for whatever purposes they need. (its 1 workbook with 5 sheets)
now the problem is a little complicated to explain. But I use a few "VLOOKUP"'s to fill in data for them in the spreadsheets..this works great if the vlookups occur on fields where the data is in there from the export from the database..if it is not it does not work because of a formatting issue. heres an example:
I use vlookup up the the policy# field it works fine if the policy# field is filled in from the dbase export. If it is not you cannot manually enter the policy number you have to copy it from somewhere else ont he page that has exported the policy number and then paste it into the field your trying to add!
Ive checked the formatting..they are all consistent so I have no idea why it matters..but it does..
if anyone understood what I was talking about and can give me any clues please let me know..this one just doesnt make any sense..
and thanks to all who have answered by previous 2 posts i appreciate it
-Ins