please solve the problem

S

somaraju

i have 2 workshets

1st one is for puchases
2nd one is for sales

now i want to open the 3rd sheet as stock. when i enter the sales
it is automatically show values in stock file.

any one tell me which can i uses the functions.
 
F

flummi

Hope I get you right.

Stock on sheet "Stock":

prod stock
abc 13
abb 44
edd 33
gdd 66
uhh 16

Sales on sheet "Sales":

prod sales Stock
aaa 15 0
abb 22 44
err 19 0
dddf 30 0

Formula in column C for finding stocks:
=IF(ISNA(VLOOKUP(A2;Stock!$A$2:$B$6;2;FALSE));0;VLOOKUP(A2;Stock!$A$2:$B$6;2;FALSE))

You may have to replace the semicolons with commas.

Hans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top