Does anyone know how I would change the below formula into one that would return text? Your help is greatly appreicated.
=SUMIFS('Previous Day'!M:M,'Previous Day'!I:I,Tracking!H5,'Previous Day'!G:G,Tracking!J5)
'Previous Day'!M:M = The text
'Previous Day'!I:I, = Selection of all Codes for Catagorisation
Tracking!H5, = Code
'Previous Day'!G:G, = Selection of all sub codes
Tracking!J5 = sub code
Thanks in advance guys!
Hi and welcome to the forum.
Looks like an INDEX & MATCH issue..
Be sure that best way to describe your problem is to upload a sample workbook.
Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.
To attach a small sample workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
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.
Here is the example suggested above.
The columns I care about feeding the data from Previous day to are K:N that data comes from columns K:N in the previous day sheet. This is based on the GIN and SET ID matching from the previous day sheet.
JJ
I am sorry that i don't understand at all which is your goal! Maybe my English..?
In K5 use this array formula
=INDEX('Previous Day'!K:K,MATCH($B5&$J5,'Previous Day'!$B:$B&'Previous Day'!$G:$G,0))
..confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Copy across.
Life's a spreadsheet, Excel!
Say thanks, Click *
=INDEX('Previous Day'!M:M,MATCH($B6&$J6,'Previous Day'!$B:$B&'Previous Day'!$J:$J,0))
Using this, appears like it should work, but it doesn't.
scratch that, it works!!!! THANK YOU!
but when I autofill it just autofills the same thing as the cell I am filling from, the formula is adapting but doesn't retireve the correct result without me refreshing the cell.
Last edited by jamesjy90; 07-18-2013 at 07:15 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks