hi to all!!
Im having problems with the vlookup function, I have two big ddbb of about 30x1500 each and im trying to add data from one of them to the other using the vlookup fuction. the common field for both DDBB is the id number. this numbers match one to one in both DDBB (i have checked that by doing a pivot table) but when it comes to comparing both ID numbers on Datbases. Many Id numers are not recongnized by the vlookup function giving me an N/A like the number wasnt there.i check one ID number in both ddbb and they are the same. I dont know what is the cause for that .All the fields are numbers.
I hope any of you have an idea of what is happening, the issue looks that easy that i dont know what ican try
I have attatched a little example of both data bases and the vlookup function not working
thanks in advance to you all!
Carlos
Bookmarks