Forum Discussion

Vicky1770's avatar
Vicky1770
Copper Contributor
Jul 22, 2019

vlookup

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 ...
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Jul 22, 2019
Try this formula in cell F2 and copy down:

=VLOOKUP(E2,$A$2:$B$2919,2,FALSE)
  • Vicky1770's avatar
    Vicky1770
    Copper Contributor
    Jul 22, 2019

    Thank you so so so much. I appreciate your help so much.

     

    Have a great day!!!