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

Related Conversations
Custom value if a value is found using vlookup
Sam55 in Excel on
5 Replies
vlookup using concatenate function and helper column
Angela McGhin in Excel on
4 Replies
Vlookup doesn't work for inexplicable reason
Domonkos in Excel on
2 Replies
vlookup
BowlingAlleyBob in Excel on
3 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Need some help with my Vlookup or a new idee
Jim Brastad in Excel on
5 Replies