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, IT Consultant
Category: Microsoft Office
Satisfied Customers: 397
Experience:  CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
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
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: 8 months ago.
Category: Microsoft Office
Expert:  bbao replied 8 months 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 8 months 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.

Related Microsoft Office Questions