vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-768024%22%20slang%3D%22en-US%22%3Evlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768024%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20a%20simple%20vlookup%20formula%20and%20the%20formula%20will%20return%20a%20value%20until%20the%20patient%20ID%20is%20not%20found%20in%20sheet%202%20and%20if%20the%20patient%20ID%20is%20not%20found%20then%20it%20returns%20NA%20which%20is%20ok%20but%20the%20Vlookup%20will%20not%20continue%20searching%2C%20it%20returns%20NA%20for%20the%20remainder%20of%20the%20Patient%20IDs.%20Can%20someone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-768024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768084%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768084%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380247%22%20target%3D%22_blank%22%3E%40Vicky1770%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMay%20be%20you%20need%20to%20freeze%20the%20data%20array%20by%20putting%20%24%20sign%20within%20cell%20reference.%3C%2FP%3E%3CP%3EYou%20may%20share%20your%20file%20so%20that%20more%20suitable%20solution%20cane%20be%20provided.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETauqeer%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768101%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3BCan%20you%20look%20at%20the%20document%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768107%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768107%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380247%22%20target%3D%22_blank%22%3E%40Vicky1770%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20adjusted%20formula%20in%20your%20file%2C%20hope%20it%20will%20serve%20your%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768113%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768113%22%20slang%3D%22en-US%22%3ETry%20this%20formula%20in%20cell%20F2%20and%20copy%20down%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DVLOOKUP(E2%2C%24A%242%3A%24B%242919%2C2%2CFALSE)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768117%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768117%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20so%20so%20much.%20I%20appreciate%20your%20help%20so%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20great%20day!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Vicky1770
New Contributor

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?

5 Replies

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 

@tauqeeracma Can you look at the document please?

Hi @Vicky1770 

 

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

 

Thanks

Tauqeer

Try this formula in cell F2 and copy down:

=VLOOKUP(E2,$A$2:$B$2919,2,FALSE)

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

 

Have a great day!!!