Here is the Issue. I have two colums, one has a list of my SKUS (colum A) and another has a list of SKUS from another company (colum B) with quantities (colum C). I need the value in A1 to search through Colum B for the that value then paste the Quantity matching in the same row in D1.
Put this formula in D1 and fill down:
=VLOOKUP(A1,$B$1:$C$230,2,FALSE)
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
This is the result i get #N/A
Then there is no match.
See my example.
I added the blue cell.
The result is in the yellow cell.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
See attached file, why will the vlookup not match any values. If you control find the number its does have a corresponding value
---------- Post added at 12:27 PM ---------- Previous post was at 12:26 PM ----------
The VLOOKUP does not work here and I Cannot figure it out. Please help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks