VLOOKUP combined with AND
All of your responses worked. Thanks, sometimes it is a matter of wrapping
your head around the problem in the right context, and my head is built for
things that wiggle in a petri dish! Much appreciated all of you!
"muddan madhu" wrote:
try this ( use ctrl + shift + enter )
assumed Range (A1355:A2244 ) has patient number
Range (B1355:B2244 ) has Date
Range (C1355:C2244 ) has Time
Heart rates are in Col F.
=INDEX(A1355:G2244,MATCH
(A19&B19&C19,A1355:A2244&B1355:B2244&C1355:C2244,0 ),5)
On Nov 18, 10:43 pm, Lost in Microbiology
wrote:
Is it possible to nest the AND function with VLOOKUP? I think I have the
formula entered correctly, but get the dreaded #N/A. It may be my date in the
lookup does not match my array, but I think I hve that corrected, yet it
still doesn't work.
Example of formula =VLOOKUP(AND(A19, B19, C19),A1355:G2244,5,FALSE)
I have a patient number, date and time, from my current worksheet, and I
pasted an array below to lookup the patient, date and time to match their
heart rate.
Thanks for any guidance!
|