Searching through a range for a specific text and having it out into a different cell

Hi!

I have a massive 2000 odd list of of SKUs in different statuses that have Accepted and Invoiced information in different columns.

I have attached to an example sheet with some raw data and how I'd like to have it shown at the bottom.

Is it possible to do this without using macros? This way I can then take pieces of this and add this to my excel-fu.

Thank you!!

Hi @laurigardner

I suppose you make a mistake in your data in A3:A8. I use in first column the SKU number ordered AA1, AA2, ....

Solution:

The first two columns are the same

Try in I14 and copy down and forward the following formula

Formula:

Please Login or Register  to view this content.

See the file where my solution is in G21:J28

You beautiful beautiful person you!!

Thank you!

This saves me hours of work!

You are welcome.