I need to find a value in a column based on the column's heading and a
certain number a couple columns away. This info is not static, so I
need a formula robust enough to always look for the column with 'PCB'
as the header, and a particular number in the PCB column. Then it
needs to find the total number of PCBs scheduled in a column that has a
date heading.



Attached is a picture with an example of what I'm talking about.
Currently I'm using a formula that will always look in column G for the
number and then lookup G+2 for the amount.

Here is the formula I'm using now. $A4 is the PCB number in the
spreadsheet that this formula is in.
=SUMIF('[LocalFile.xls]102-1'!$G:$G,$A4,'[LocalFile.xls]102-1'!$K:$K)

Looking for robustness!!
Thank you!!


I apologize for all of the censored info ;)
Kurtis


+-------------------------------------------------------------------+
|Filename: example.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3417 |
+-------------------------------------------------------------------+

--
JimVarney01
------------------------------------------------------------------------
JimVarney01's Profile: http://www.excelforum.com/member.php...o&userid=23588
View this thread: http://www.excelforum.com/showthread...hreadid=373745