F
f_pamela
I have two sheets on one model number, cost, on the second sheet several
models with sales prices by districts, like 50,51,55,58,61, now i need to
find the price of disctrict 50 for this model and then the price for the
disctric 51 etc, how can i do this formula? i have a lot of models and need
to find the prices for each district.
example
on sheet one
model number cost 50 51 55 58 61
123 $10.61 ? ? ? ? ?
second sheet
model price disct
1234 609 50
1234 609 51
1234 609 55
1234 609 58
123 609 50
123 609 51
123 609 58
123 649 60
1854 649 55
1854 649 60
18547 649 55
Thank you for yout help
models with sales prices by districts, like 50,51,55,58,61, now i need to
find the price of disctrict 50 for this model and then the price for the
disctric 51 etc, how can i do this formula? i have a lot of models and need
to find the prices for each district.
example
on sheet one
model number cost 50 51 55 58 61
123 $10.61 ? ? ? ? ?
second sheet
model price disct
1234 609 50
1234 609 51
1234 609 55
1234 609 58
123 609 50
123 609 51
123 609 58
123 649 60
1854 649 55
1854 649 60
18547 649 55
Thank you for yout help