I have an INDEX MATCH MATCH formula working pretty well, pulling data from one table into another(exact same table, just a different tab). However in rows 87 and 126 I get "0" and then" the rest is ":#REF!" and then the formula starts working again in the row below..
Any Ideas?
Here is my formula.
=INDEX('1Q10_Pivottable'!$B$5:$AM$162,MATCH(C87,'1Q10_Pivottable'!$A$5:$A$162,0),MATCH(G$6,'1Q10_Pivottable'!B$4:AM$4,0))
Many thanks,
Eve
Is something different in C87 &C126, from the other C values(C5:C86, C88:162)...??
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.
Perhaps you need to LOCK the B4:AM4 reference in the 2nd Match..
And the C87 in the first match
=INDEX('1Q10_Pivottable'!$B$5:$AM$162,MATCH($C87,'1Q10_Pivottable'!$A$5:$A$162,0),MATCH(G$6,'1Q10_Pivottable'!$B$4:$AM$4,0))
Last edited by Jonmo1; 05-24-2013 at 09:34 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks