View Single Post
 
Old 06-02-2014, 12:59 PM
thatgirlaudrey thatgirlaudrey is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2014
Posts: 2
thatgirlaudrey is on a distinguished road
Default Confusion on INDIRECT function

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
File Type: xlsx Raw Data.xlsx (9.7 KB, 10 views)
File Type: xlsx desired result.xlsx (10.3 KB, 11 views)
Reply With Quote