Getting additional information from secondary worksheet

I have a master worksheet that lists stock items. The master worksheet checks information against 5 additional worksheets & tells me if these stock items are listed on them or not using (=if(isnumber(match($A1,'worksheet'$A$1:$A$1000,0),"yes","no) this formula works well, however, i now require additional information. Is it possible to have a formula that can tell me if the item is in stock or not and what the sales history of that stock item is? I have attached an example of what it is exactly that i need.

Any help will be greatly appreciated!!!!

Thanks

For the stock:

=IFERROR(VLOOKUP(B4,$B$15:$D$26,3,FALSE),"No stock")

Regards

Try:

C4: =IFERROR(VLOOKUP(B4,$B$15:$D$26,2,FALSE),"Invalid Stock Item")
D4: =IF(COUNTIF($B$15:$B$26,$B4)>0,"yes","no")
E4: =IFERROR(VLOOKUP(B4,$B$15:$D$26,3,FALSE),"Invalid Stock Item")
F4: =IFERROR(SUM(INDEX($E$15:$P$26,MATCH($B4,$B$15:$B$26,0),COUNTA($D$14:$IV$14)-3):INDEX($E$15:$P$26,MATCH($B4,$B$15:$B$26,0),COUNTA($D$14:$IV$14)-1)),"Invalid Stock Item")

and copy the formulae down

Regards