Search in Mulitple Columns and Return Corresponding Column/Row Result

Hello,

I'm hope there is a simple solution.

Basically, I need to look for an item, lets use "apple" as an example, in a range of cells, A1:D100. Then the corresponding result would be in another column in the same row.

I hope this makes sense.

Thanks!

How many times is apples going to appear in your set of data? Is it random?

What exactly are your trying to get out of your range? How many apples sold, who sold them etc?

Hi Royals2008 and Dunc3142,

The "Apple" will be a unique record within the range. Once it finds it in the range it will refer to another column on the same row as the "Apple" and provide me with that result.

I've attached a spreadsheet with what I am trying to accomplish.

Thanks!

Assuming that any item is unique to each row, try...

H5, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=SUM(IF($A$5:$B$8=G5,$D$5:$D$8))

Hope this helps!

HI Dominic and NBVC,

Thanks! Those two solutions work, however, how can the formula be changed to addess cells with a combination of letters and number or a non numeric entry?

Originally Posted by JLRO

HI Dominic and NBVC,

Thanks! Those two solutions work, however, how can the formula be changed to addess cells with a combination of letters and number or a non numeric entry?

Can you provide a small sample of the data, along with the expected result?

Hi Dominic,

Here is the example.

Hello NBVC,

Thank you for the solution and quick reponse!

Have a great week.