| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Numeric calculation
I have created an 'IF' statement which reads as follows
=IF('General Stock'!C2=1,'General Stock'!B2,"=if('General Stock'!C3=1,'General Stock'!B3,=if('General Stock'!C4=1,'General Stock'!B4,=if('General Stock'!C5=1,'General Stock'!B5,=if('General Stock'!C6,'General Stock'!B6,=if('General Stock'!C7=1,'General Stock'!B7,=if('General Stock'!C8=1,""))))))") The problem is that if the number 1 appears in the C collum of the General Stock sheet it pulls it through correctley but I need the formula to continue searching for the next correct value on the General Stock sheet. At the moment the correct answer is found in cell C3 of the General Stock sheet so it is repeated twice instead of searching for the next correct answer and pulling through that value to the first sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Threaded Mode
