• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

lookup values in 3 criteria

I think in BC2 you want
=SUMPRODUCT(($A$2:$A$22527=$AW2)*($AV$2:$AV$22527=$H2)*($BA$2:$BA$22527=BC$1))
Which returns 0
You can copy this across, but they are all zero

Please check if the logic is correct
 
Hi ,

Or probably :

=SUMPRODUCT(($AW$2:$AW$22527=$A2)*($AV$2:$AV$22527=$H2)*($BA$2:$BA$22527=BC$1))

since column A has data only till row 464.

Narayan
 
@Hui ; @NARAYANK991

i really check it more than one time and guess that some thing went wrong as i use the below function which didn't find all matching data
{=INDEX($BB$2:$BB$22527,MATCH(1,($A2=$AW$2:$AW$22527)*($H2=$AV$2:$AV$22527)*(CJ$1=$BA$2:$BA$22527),0))}

and i will check it again
thanks in advance

Afarag
 
Hi Afarag ,

Your formula should work ; try this in BC2 :

=IFERROR(INDEX($BB$2:$BB$22527,MATCH(1,(($A2=$AW$2:$AW$22527)*($H2=$AV$2:$AV$22527)*(BC$1=$BA$2:$BA$22527)),0)),"00:00:00")

and copy across and down.

Where there is a match , you will see the corresponding time entry.

Narayan
 
@Hui
it's my problem from the first as the attached sheet isn't the same sheet that i handle, as the main sheet contain more than 90,000 rows and have large size to upload so that the sample data that i posted didn't meet all match criteria

and what about of the another topic that i posted the same thread to another reference as i can't upload the file here, and sometimes face an error when upload file so that i directed to another reference


Gratefully,
 
In addition what hui already said.
No need to upload the file here, You could also share the file link as used there.
 
You must log in or register to reply here.
Back
Top