Jul 22 2019 09:28 AM
I am using a simple vlookup formula and the formula will return a value until the patient ID is not found in sheet 2 and if the patient ID is not found then it returns NA which is ok but the Vlookup will not continue searching, it returns NA for the remainder of the Patient IDs. Can someone help?
Jul 22 2019 09:56 AM
Hi @Vicky1770
May be you need to freeze the data array by putting $ sign within cell reference.
You may share your file so that more suitable solution cane be provided.
Thanks,
Tauqeer
Jul 22 2019 10:01 AM
@tauqeeracma Can you look at the document please?
Jul 22 2019 10:07 AM
Jul 22 2019 10:08 AM
Jul 22 2019 10:10 AM
Thank you so so so much. I appreciate your help so much.
Have a great day!!!