J
JimVarney01
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 |
+-------------------------------------------------------------------+
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 |
+-------------------------------------------------------------------+