Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Exact Match using INDEX, MATCH DoubleUU Excel Worksheet Functions 3 August 15th 08 02:42 PM
index(match) Wind Uplift Calculations (match four conditions) JMeier Excel Worksheet Functions 8 August 1st 08 01:45 AM
index match array function-returning only first match, need last. Julie Olsen Excel Worksheet Functions 3 December 29th 06 12:50 AM
How do I display more than one match in a Index/Match formula? Trish Excel Worksheet Functions 0 September 26th 05 10:21 PM
index,match,match on un-sorted data Brisbane Rob Excel Worksheet Functions 3 September 24th 05 10:04 PM


All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"