Microsoft Office Questions? Ask a IT Expert for Support ASAP
Before I ask you to send the file could you please paste the formula here in your reply so I can check the syntax
Ok the column_index parameter is missing (i.e. 3rd parameter), assuming of course that that file exists.
Try this, then you can replace the "1" in the formula with the actual column index that you want to pull data from
=Vlookup(A28,'[incidents by vendor by day - dm.xlsx]Sheet1'!$A:$B, 1, false)
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
Ok try this
Type Joe in A28 in the current file
Then open the source file and type Joe in A5, and type Doe in B5
What does the formula return?
Ok that means the formula is correct and the problem is with your data, most likely it is not able to find an exact match. Try replying the False with True to see if catches the next match
Hope this helps.
There must be an issue with the data. The only way I can resolve this is for me to have both files so I can thoroughly check the data. I don't mind doing that but I think at this point you need to accept so I make sure I get paid for my work thus far. You can add bonus upon completion if you like
Let me know if you need help uploading the files
Yes, thanks. I sent you the instructions a while ago but apparently they did not get posted!
Here it is again
Please go to http://www.wikisend.com/ and upload the file there (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
Let me know in which cell that formula is
Ok try this site instead
Were you able to upload the file
No you do not need to use the email box. Just click Browse, select your file, click Upload, then copy the download link that you will get and post here
So where is the source file that the formula is pulling the data from?
I am looking at first file...
So the lookup table (source data) is in columns A and B on that sheet
And the formula is in cell D5 on the same sheet
And the name to look for is in A5 on the same sheet
Here you go
Ok the reason you are getting the #N/A! error is because no matches could be found and that is basically because the names on that sheet have leading spaces. I modified the formula so it will ignore these spaces
Here is the file with the formulas in the new yellow cells. Make sure the source file is open so the formulas can be pull the values
Hope this is ok.
Please make sure to remove the Neutral Feedback that you left me earlier which is not really fair or warranted.