hello
having some trouble with 2 set of criteria implementing into the index match
=INDEX($C$2:$K$11,MATCH($C19,$C$3:$C$11,0),MATCH(D$18,$D$2:$K$2,0))
i have highlighted in yellow
can somone one pls help....basically its not giving me the value from the table.
Last edited by jw01; 07-19-2012 at 12:32 AM.
Hi
D20:
=INDEX($D$3:$D$11,MATCH($C20,$C$3:$C$11,FALSE),1)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
your ranges are all over the place, use the following:
Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Originally Posted by icestationzbra
your ranges are all over the place, use the following:
Please Login or Register to view this content.
thxs alot pal
i see my first match formula had to start at cell C2
appreciate the help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks