Results 1 to 4 of 4

Help with INDEX

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2008
    Location
    Fremont
    Posts
    21

    Help with INDEX

    I am trying to perform a simple look up and part one is working but the second isnt...

    Heres what im using...

    =SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)) THIS Works as shown in the Jpg Formula (BBB) image im enclosing...

    =INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)) -- THis is not Formula (CCC) as shown in the jpg. Yes i have done the CTRL+SHIFT+ENTER but i still get a refference error... Ive tried different variations..but no luck...Please help :-)
    Attached Images Attached Images
    Last edited by menor59; 10-01-2008 at 10:22 PM. Reason: add references

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is there a way to clear all variables after a loop?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-12-2008, 11:34 AM
  2. Check cells for color index and delete
    By randolphoralph in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 07-30-2008, 07:07 PM
  3. Comments copied to Index from worksheets
    By KennyE in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2008, 09:50 AM
  4. Problem with INDEX formula
    By jhvyoung in forum Excel General
    Replies: 5
    Last Post: 12-05-2006, 05:42 PM
  5. Summ based 2 index
    By sal21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2006, 07:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1