Hi. Please see the attached file. It's actually a Hlookup problem, but with multiple criterias. So I thought I could use index match match? But I can't make it work - why?
Hi. Please see the attached file. It's actually a Hlookup problem, but with multiple criterias. So I thought I could use index match match? But I can't make it work - why?
Plz see the attachment. I have used a helper row in row 3.
Formula:Please Login or Register to view this content.
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
Hi
Use this ARRAY formula.
=INDEX(6:6;MATCH(2014&"Actual";3:3&2:2;0))
=INDEX(6:6,MATCH(2014&"Actual",3:3&2:2,0))
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
You can also adapt Fotis's solution slightly so that it is non-array-entered:
=INDEX(6:6,MATCH(2014&"Actual",INDEX(3:3&2:2,,),0))
Regards
@Fotis1991: Thanks, that what exactly what I was looking for! Btw, do you know of any particularlysite that explaines how to use arrays formulas for beginners like me? Otherwise, I'll just google myself .
@Rajeshturaha: Thanks for your constribution, but I'll stick to Fotis1991' solution since it fits better to my actual worksheet .
@XOR LX: Didn't see your post - thanks! Sorry if it's a stupid question, but (in general) is it better to make a formula non array, if it's possible?
You are welcome and thanks for the feed back.
Take this as a rule: If you have a solution with regular formula then don't use an ARRAY formula!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks