Thread: Match, Index
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shortstopper00 Shortstopper00 is offline
external usenet poster
 
Posts: 11
Default Match, Index

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