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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks