VLOOKUP combined with AND
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!
|