I have the following BIG problem: I want to extract some information from a data base given certain criteria like a data range and a specific job name. Already I tried with the MATCH, INDEX, VLOOKUP, but I don’t find the correct answer because I can find the first value of my job name, but when I want extract the second value there is a problem.
Thanks for your help, attached is the file.
Regards
jongova
New+Bitmap+Image (1).jpg
Last edited by jongova; 11-07-2012 at 04:17 PM.
Try in K6 and copy down.
=SUMPRODUCT(($A$2:$A$17=$H$3)*($B$2:$B$17>=$H$6)*($B$2:$B$17<=$H$7)*($C$2:$C$17=J6)*($D$2:$D$17))
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.
[Edit] Post Deleted
I think best if you set up a dummy column, let's say starting in F2 (you can hide this column later if you like)
=IF(AND(A2=$H$3,B2>=$H$6,B2<=$H$7),$H$3&"_"&COUNTIF($F$1:F1,$H$3&"*"),"")
Then in J2 dragged across and down
=IFERROR(INDEX(C$2:C$17,MATCH($H$3&"_"&ROW(A1)-1,$F$2:$F$17,0)),"")
See attachment
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
ChemistB
Yes, this works excelent! thanks a lot!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks