Johnboy28
Board Regular
- Joined
- Jun 22, 2013
- Messages
- 207
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Hi - is there a way to change this formula to pick up text? as I need to be able to pick up the Plan. Lookup would need to match the No and return Plan.
=IF(SUMIF(INDIRECT($C$4),A9,INDIRECT($C$6))=0,"0",(SUMIF(INDIRECT($C$4),A9,INDIRECT($C$6))))'
=IF(SUMIF(INDIRECT($C$4),A9,INDIRECT($C$6))=0,"0",(SUMIF(INDIRECT($C$4),A9,INDIRECT($C$6))))'
No. | Wgt | Plan | |||||
Weights & No. | 1 | 282 | FJ | ||||
No. | Yield!f:f | 2 | 296 | JP | |||
Plan | Yield!h:h | 3 | 344 | FD | |||
Wgt | Yield!g:g | 4 | 255 | Woody | |||
5 | 242 | Apple | |||||
No. | Wgt | Plan | 6 | 156 | HG | ||
1 | 281.90 | ?? | 7 | 185 | Orange | ||
2 | 295.90 | 8 | 265 | Woody | |||
3 | 344.40 | 9 | 305 | FD | |||
4 | 255.00 | 10 | 288 | FJ | |||
5 | 242.00 | 11 | 422 | JP | |||
6 | 156.00 | 12 | 120 | FJ |