Vicky1770Copper ContributorJul 22, 2019vlookup 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 ...Show More
PReaganBronze ContributorJul 22, 2019Try this formula in cell F2 and copy down:=VLOOKUP(E2,$A$2:$B$2919,2,FALSE)
Vicky1770Copper Contributor to PReaganJul 22, 2019Thank you so so so much. I appreciate your help so much. Have a great day!!!
