Hi Everybody!
I give up! I've been trying to correct the formula using If(Iserror) but I must be missing something. I wanted to get the balance of Qty & Cost of my stock using Index & Match removing any errors.
Pls. help..
Thanks!
Hi Everybody!
I give up! I've been trying to correct the formula using If(Iserror) but I must be missing something. I wanted to get the balance of Qty & Cost of my stock using Index & Match removing any errors.
Pls. help..
Thanks!
Last edited by rickyilas; 02-26-2010 at 11:10 AM.
Try:
=IF(ISNUMBER(MATCH(C27,$C$5:$C$16,0)),INDEX($D$5:$D$16,MATCH(C27,$C$5:$C$16,0)),0)-IF(ISNUMBER(MATCH(C27,$C$19:$C$23,0)),INDEX($D$19:$D$23,MATCH(C27,$C$19:$C$23,0)),0)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Exactly! Thanks NBVC!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks