Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional lookup
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |