Forum Discussion
data validation on two cells gives result in third cell
Hi,
The Weight Tracker is look great 🙂
So to explain, taking an Old English, she weighed in at 15.3Kg, her target weight is 23 to 27Kgs
Which means she is between 7Kg and 11.7Kg under her true weight.
In C10 it would give the difference from the weight and target weight
C11 it would give the date to the target weight in this case 23 to 27Kg if she gains 1 Kg a week, 7 to 11.7 weeks
Sorry if am not explaining myself right.
When as suggested before. Drop-down list for the Breed will be Ideally Weight[Breed] column, for Gender just Male,Female.
If we name as Range data in both Male and Female columns of Ideally Weight, when Target Weight could be taken as
=INDEX(Range, MATCH(Breed, IdeallyWeight[Breed], 0), IF(Gender="Male",1,2) )
When entering that formula I get a #NAME? error
Ideally Weight (TAB)
I really appreciate your support in this 🙂
I guess you didn't define names Breed, Range and Gender in workbook. Alternatively you may use proper cell references.