Anbuselvam K
Member
Hi
Please find the attached file. In that file Batch number sheet i've used sumproduct formulation to get the no of batch number from master data sheet. i got the answer is 4 by counting the cells, but i need to get the values from that 4 cells (AB24, AB25, AB26, AB27).
My Input will be in Batch Number Sheet C3, I need result in C4 and C5.
Thanks in Advance!
Please find the attached file. In that file Batch number sheet i've used sumproduct formulation to get the no of batch number from master data sheet. i got the answer is 4 by counting the cells, but i need to get the values from that 4 cells (AB24, AB25, AB26, AB27).
My Input will be in Batch Number Sheet C3, I need result in C4 and C5.
Thanks in Advance!