L
Lost in Microbiology
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!
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!