| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP combined with AND
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup combined with Hlookup | Excel Worksheet Functions | |||
| vlookup combined with AND-function | Excel Worksheet Functions | |||
| vlookup and match combined? | Excel Worksheet Functions | |||
| Combined VLOOKUP AND BETWEEN FUNCTION | Excel Worksheet Functions | |||
| vlookup / len function combined | Excel Discussion (Misc queries) | |||
Threaded Mode
