S
Shortstopper00
I need a formula for set of data. The user picks to options and from a chart
I need the number brought back. Example
Norway Maple Yes 9.5
Red Maple Yes 15
Silver Maple Yes 19
Norway Maple No 9.5
Red Maple No 15
Silver Maple No 19
I user would put in red maple and no...and 15 would be brought back. I was
using the code
=INDEX(N3:N48,MATCH(Ctree,L3:L48,0),MATCH(CLeaf,M3:M48,0))
Ctree = type of tree
Cleaf = yes or no
Now it would bring the answer back for any values with Yes but nothing for
No's. There was a reference error....Any Suggestions
I need the number brought back. Example
Norway Maple Yes 9.5
Red Maple Yes 15
Silver Maple Yes 19
Norway Maple No 9.5
Red Maple No 15
Silver Maple No 19
I user would put in red maple and no...and 15 would be brought back. I was
using the code
=INDEX(N3:N48,MATCH(Ctree,L3:L48,0),MATCH(CLeaf,M3:M48,0))
Ctree = type of tree
Cleaf = yes or no
Now it would bring the answer back for any values with Yes but nothing for
No's. There was a reference error....Any Suggestions