I have three tabs. The first tab contains the table with VLOOKUP formulas. The second tab is the budget I download from the network server. The third tab contains information I download from PeopleSoft. The file downloads as a .cvs file and I save the downloaded file as an Excel file and then copy and paste the data into my worbook,
The lookup number will only return information from one of the tabs, but not both. (I have them formulas in separate columns) I know it has something to do with the way thet project numbers are formatted. If I copy and paste a project number from the budget tab to the VLookup tab, I get the information from the budget tab. If I copy and paste a project number the PeopleSoft tab into the VLookup tab, I get the PeopleSoft information.
What I don’t understand is my formulas worked great for the last couple of months, but something must have changed because now they just don’t work.
I have tried formatting the numbers anyway I can, but nothing works. Could someone advise me?
Thanks in advance for any help you can give me.
The lookup number will only return information from one of the tabs, but not both. (I have them formulas in separate columns) I know it has something to do with the way thet project numbers are formatted. If I copy and paste a project number from the budget tab to the VLookup tab, I get the information from the budget tab. If I copy and paste a project number the PeopleSoft tab into the VLookup tab, I get the PeopleSoft information.
What I don’t understand is my formulas worked great for the last couple of months, but something must have changed because now they just don’t work.
I have tried formatting the numbers anyway I can, but nothing works. Could someone advise me?
Thanks in advance for any help you can give me.