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 :-)
Last edited by menor59; 10-01-2008 at 10:22 PM. Reason: add references
You need to post a sample of your workbook: We can't troubleshoot formulas via a picture (they just don't help) and it's a bother to try to create a test file from scratch ( can't copy/paste from jpg's).
Ben Van Johnson
well the simpler formula that is used is a vlookup of an index andd match function, I will give you the second as you seem familiar with index
Is that what you want
Please Login or Register to view this content.
Regards
Dav
You're almost there
Please Login or Register to view this content.
I need your support to add reputations if my solution works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks