Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jambruins
 
Posts: n/a
Default Why isn't this formula working?

I have the following formula (which works find) in cell H2

=VLOOKUP("RED",Scores!K:N,3,0)

I have the following formula in cell H3 which is not working. Any ideas why?

=IF(ISTEXT(INDEX(Scores!$M$1:$M$49997,SMALL(IF(Sco res!$K$1:$K$49997="RED",ROW(INDIRECT("1:50000"))), ROW()-1))),(INDEX(Scores!$M$1:$M$49997,SMALL(IF(Scores!$ K$1:$K$49997="RED",ROW(INDIRECT("1:50000"))),ROW()-1))),"")

Thanks
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

You'd expect it to wouldn't you, they are so similar!

--
HTH

Bob Phillips

"Jambruins" wrote in message
...
I have the following formula (which works find) in cell H2

=VLOOKUP("RED",Scores!K:N,3,0)

I have the following formula in cell H3 which is not working. Any ideas

why?


=IF(ISTEXT(INDEX(Scores!$M$1:$M$49997,SMALL(IF(Sco res!$K$1:$K$49997="RED",RO
W(INDIRECT("1:50000"))),ROW()-1))),(INDEX(Scores!$M$1:$M$49997,SMALL(IF(Scor
es!$K$1:$K$49997="RED",ROW(INDIRECT("1:50000"))),R OW()-1))),"")

Thanks



  #3   Report Post  
bj
 
Posts: n/a
Default

Have you tried looking at each section individually for an error.
I have not looked through the logic of the formula but you do have different
sized arrays. I have not verified that all of them which need to be the same
are.
I also assume you entered it with the control-shift-enter.
what is your error message?


"Jambruins" wrote:

I have the following formula (which works find) in cell H2

=VLOOKUP("RED",Scores!K:N,3,0)

I have the following formula in cell H3 which is not working. Any ideas why?

=IF(ISTEXT(INDEX(Scores!$M$1:$M$49997,SMALL(IF(Sco res!$K$1:$K$49997="RED",ROW(INDIRECT("1:50000"))), ROW()-1))),(INDEX(Scores!$M$1:$M$49997,SMALL(IF(Scores!$ K$1:$K$49997="RED",ROW(INDIRECT("1:50000"))),ROW()-1))),"")

Thanks

Reply
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
Simplify formula Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM
Looking for a working production formula so I can add to staff? JJL Excel Discussion (Misc queries) 0 March 11th 05 05:11 PM
Formula entered not working Thrava Excel Discussion (Misc queries) 5 March 6th 05 10:18 PM
Formula not working Carl Hilton Excel Worksheet Functions 13 January 9th 05 07:55 PM
Relative Indirect Formula Referencing? Damian Excel Worksheet Functions 1 January 7th 05 05:16 AM


All times are GMT +1. The time now is 01:28 AM.

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

About Us

"It's about Microsoft Excel"