Dr.TofyGuy
New Member
- Joined
- Jul 26, 2007
- Messages
- 24
hi every one i am in a situation and i need help
will i have sheet with 4 taps
1st with the data names
2nd till 4th contain data
i will illustrate what i need
in the first tap, their is the inventory name in column A " in contains several names " and in column B it contains all the products name
and in tap 2,3,4 it contains the inventory names in column a, product name in column b and in column the remain amount in the inventory
will what i need is a formula to look in the 3taps looking matching the inventory name, then the product name then reading the remaining
is this possible
will i have sheet with 4 taps
1st with the data names
2nd till 4th contain data
i will illustrate what i need
in the first tap, their is the inventory name in column A " in contains several names " and in column B it contains all the products name
and in tap 2,3,4 it contains the inventory names in column a, product name in column b and in column the remain amount in the inventory
will what i need is a formula to look in the 3taps looking matching the inventory name, then the product name then reading the remaining
is this possible