At the risk of sounding like a total idiot.. I need help with the INDIRCT function.
I have a list of part numbers in column B, with program numbers in column A - the program numbers make up a part number. Decriptions are in Columns C, D, E.
I need to read by part number- orizontally listed by program number and by machine code.

I have attached the sample of each to get an idea of what I have, and what I need.

I've tried to wrap my brain around the idea of the formula, and I end up even more confused from when I started. Tried reading old forum threads.. that didnt help!

Attached Files

	Raw Data.xlsx (9.7 KB, 10 views)
	desired result.xlsx (10.3 KB, 11 views)

Hi
Maybe you uploaded the wrong files? I can't see the intended match on the partnumbers, or did I misunderstand your question?

The Indirect function can indeed complicate a formula, and we'd like to help. But I'm with whatsup, audrey, I don't see any link from desired result.xlsx to Raw Data.xlsx. If you're having trouble uploading files, and can't make it work right, maybe you can describe it some more.

Ignoring that the data in one are not the same as the data in the other, it appears what she wants is (borrowing a term from Access) a cross tab query with part no's in the rows, operations in the columns, and programs at the intersections.

If that's the case and if it is also the case that there can only be a single program at any part/operation intersection, this can be easily jerry-rigged. In Access, as alluded to earlier, this is a cross tab query. In Excel, it can be done with a pivot table (see attached). I'm not sure if there's a way to suppress the grand totals calculations. They are not relevant.

Other than that, if there's a better way to do this with equations of one sort or another, I will think about that after some clarification from the OP.

Attached Files

Raw Data.xlsx (13.6 KB, 7 views)

I apologize for the confusion- I thought I explained it better- at least it sounded good in my head- I clearly was more confused than I originally thought.
The result I need looks identical to the pivot table that gebobs showed-
that thought never crossed my mind- I figured indirect was the way to go, since vlookup/hlookup wouldn't work since there were program numbers were not specific to each part number.
I will give a pivot table a try and see if it will merge everything together.

Thank you everyone!!