vlookup

Question

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?

tauqeeracma · Answer

Hi Vicky1770&nbsp;&nbsp;I have adjusted formula in your file, hope it will serve your need.&nbsp;ThanksTauqeer

vicky1770 · Answer

Thank you so so so much. I appreciate your help so much.&nbsp;Have a great day!!!

tauqeeracma · Answer

Hi&nbsp;Vicky1770&nbsp;&nbsp;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.&nbsp;Thanks,Tauqeer&nbsp;

vicky1770 · Answer

tauqeeracma&nbsp;Can you look at the document please?

preagan · Answer

Try this formula in cell F2 and copy down:=VLOOKUP(E2,$A$2:$B$2919,2,FALSE)

Forum Discussion

vlookup

5 Replies