Question: how can I use excel index and match function to return information even if there are duplicates of the thing I'm searching? Current I get

how can I use excel index and match function to return information even if there are duplicates of the thing I'm searching? Current I get #N/A when an item is not found, but I noticed when there are doubles it will show #N/A also; need it to return at most of the results in the data even if there are doubles of an item. Please show screenshot of formula with an example.

how can I use excel index and match function to return information

ITEM AMOUNT 41107119-741 34 | Return any of these two when searching the item(s). 41107119-741 36

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

using the following: fill in the blanks using excel formulas. use the following directions: Macro Enable file upon uploading. Your job is to build an amortization schedule that will allow for extra...

Excel_7G_Loan_Staff_Revenue Project Description: In this project, you will be named range and use it to sot atsvaidation you will use a PMT function to calculate a value and then used in a two...

Introduction Note: Circular Buffers are described in Section 5.2.4 of our textbook (p. 211). Please read that section before proceeding. An interesting, relatively straightforward data structure is...

Ratings and Reviews - Part 3 For part 3 of ratings and reviews you are provided the solutions to part 2 with a few modifications as a starting point. You will further modify this solution to be able...

please answer the question correctly. Show the correct code, and the output of the code provided on screen. Please ensure its correct QUESTION: Ratings and Reviews - Part 3 For part 3 of ratings and...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Step 1: Implement Ratable and Refactor Song Create an abstract class called Ratable in the code.ratables package and refactor the Song class to extend Ratable. This class will be extended by any...

For the exclusive use of F. Ortolano, 2015. 9-910-036 REV: APRIL 11, 2011 BENJAMIN EDELMAN THOMAS R. EISENMANN Go oogle In nc. Go oogle's mission is to organize the world's inf n nformation and make...

4- The correct written form of the number 24 is twenty four. * true O False Do you like cats? No, I hate. . * O a- them b-b- their

The ledger of Rios Company contains the following balances: Owners Capital $30,000; Owners Drawings $2,000; Service Revenue $50,000; Salaries and Wages Expense $27,000; and Supplies Expense $7,000....

ans pls If an asset is to be classified as held for sale, which of the following conditions does NOT apply? There is an active program to find a buyer. @ Changes to the sale plan are likely. The sale...

Click the "draw structure" button to launch the drawing utility. Draw a second resonance structure for the following ion

How can classroom learning be designed to ensure that each student is motivated by his or her felt needs for new learning rather than using a one size fits all approach?

McGregor calls for broad involvement in management development by leaders at all levels. To what degree has that become a reality today?

As a small entrepreneurial organization develops, at what point might you expect it to shift into a formal matrix structure (with different people in staff and line roles)at 10 people, 25 people, 50...