Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2014, 12:59 PM
thatgirlaudrey thatgirlaudrey is offline Confusion on INDIRECT function Windows 7 64bit Confusion on INDIRECT function Office 2010 64bit
Novice
Confusion on INDIRECT function
 
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
  #2  
Old 06-03-2014, 04:14 PM
whatsup whatsup is offline Confusion on INDIRECT function Windows 7 64bit Confusion on INDIRECT function Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi
Maybe you uploaded the wrong files? I can't see the intended match on the partnumbers, or did I misunderstand your question?
Reply With Quote
  #3  
Old 06-03-2014, 05:18 PM
BobBridges's Avatar
BobBridges BobBridges is offline Confusion on INDIRECT function Windows 7 64bit Confusion on INDIRECT function Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #4  
Old 06-04-2014, 07:15 AM
gebobs gebobs is offline Confusion on INDIRECT function Windows 7 64bit Confusion on INDIRECT function Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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
File Type: xlsx Raw Data.xlsx (13.6 KB, 7 views)
Reply With Quote
  #5  
Old 06-06-2014, 09:23 PM
thatgirlaudrey thatgirlaudrey is offline Confusion on INDIRECT function Windows 7 64bit Confusion on INDIRECT function Office 2010 64bit
Novice
Confusion on INDIRECT function
 
Join Date: May 2014
Posts: 2
thatgirlaudrey is on a distinguished road
Default

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!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Confusion on INDIRECT function Confusion about paragraphs Sektor Word VBA 6 04-10-2014 10:29 PM
Confusion on INDIRECT function Indirect Formula with dynamic rows bluionz Excel 1 03-13-2014 11:00 AM
Filter indirect dependencies SirPercival Project 1 07-04-2012 01:03 PM
Confusion on INDIRECT function Data validation using indirect function BullMouse Excel 2 11-30-2011 05:25 PM
Indirect zleyphox Excel 1 02-11-2010 09:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft