troubleshooting Question

How do I get back values from vlookup's N/A cells?

Avatar of Smanyx
Smanyx asked on
Microsoft ExcelMicrosoft Office
4 Comments1 Solution110 ViewsLast Modified:
Hi Experts,

I have data in four columns in an Excel sheet. Column A and D represent Names while columns B and E represent their corresponding amounts. I want to be able to get out all names that are not in both name columns with their corresponding amount for further processing.
So far, I have used the vlookup function that has given me those names that are not in both columns A and D with N/A where there is no match. (This is just mock up data, I have to do this in a file of more than 65,000 records)
 screenshot
Now I want to:
  1. Sort these values in the vlookup column to get all N/A to the bottom.
  2. Then get back the actual values of these N/A cells and their corresponding amounts for further processing

So, in my example, I am more interested in getting back the following values:
Allan                  243.52
David                 203.05
Fred                   175.25
Nelson               135.22
Noah                  89.85
Pascal                 147.41
Peter                  156
Theresa              189.34

How do I achieve that?

Thanks & Regards,
Book1.xlsx
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros