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
tauqeeracma's avatar
tauqeeracma
Steel Contributor
Jul 22, 2019

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 

  • 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!!!

  • tauqeeracma's avatar
    tauqeeracma
    Steel Contributor
    Jul 22, 2019

    Hi Vicky1770 

     

    I have adjusted formula in your file, hope it will serve your need.

     

    Thanks

    Tauqeer