How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask bbao Your Own Question

bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 189
Experience:  Certified Information Systems Security Professional / Certified Information Security Manager / Microsoft Most Valuable Professional
96068672
Type Your Microsoft Office Question Here...
bbao is online now
A new question is answered every 9 seconds

I have a large list of data (19914 records) with the primary

Customer Question

I have a large list of data (19914 records) with the primary key being the one I want to use VLOOKUP. Call the variable FRUIT. The primary key occurs more than once. My lookup table has the primary key occurring just once. My formula is
=VLOOKUP(A2,$M$2:$X$158,5,FALSE)
I keep getting #N/A not available so I cant even get the first bit of lookup data.
I understand VLOOKUP will not work on multiple listing.
Help please
Submitted: 1 month ago.
Category: Microsoft Office
Expert:  bbao replied 1 month ago.

Could you please upload the spreadsheet or an example sheet so I can demonstrate you how to view data with "multiple listing"?

Expert:  bbao replied 1 month ago.

Okay, if you can't upload an example of your worksheet, just let you know your requirement can be addressed by Excel's Pivot Table feature. Please have a look at it and let me know if you can work it out yourself.