Home

Vlookup with possible nested If

%3CLINGO-SUB%20id%3D%22lingo-sub-720431%22%20slang%3D%22en-US%22%3EVlookup%20with%20possible%20nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720431%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20studying%20for%20an%20exam%20I%20am%20struggling%20with%20using%20a%20Vlookup.%20I%20have%20attached%20the%20instructions%20that%20were%20given%20to%20me%20to%20complete%20this%20assignment.%20I%20completely%20stuck%20and%20any%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20630px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120624i152F5291E70455EE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22PracticeScreenshot.png%22%20title%3D%22PracticeScreenshot.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120625i8DE24C602C1F69D5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot%202.png%22%20title%3D%22Screenshot%202.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120626i8957131C4BE44A3C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot3.png%22%20title%3D%22Screenshot3.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20248px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120627i09C58BDE58BF00F9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot4.png%22%20title%3D%22Screenshot4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-720431%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-720652%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20with%20possible%20nested%20If%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366583%22%20target%3D%22_blank%22%3E%40LianaM88%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EYou%20need%20to%20create%20a%20VLOOKUP%20(without%20any%20nesting)%20using%20an%20%22Approximate%22%20match%2C%20which%20means%20the%20last%20argument%20of%20the%20VLOOKUP%20(Range%20Lookup)%20should%20be%20either%20TRUE%20or%201%3C%2FP%3E%3CP%3EUnfortunately%20you%20did%20not%20send%20a%20file%20to%20do%20it%20for%20you%3C%2FP%3E%3CP%3EGood%20Luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Hello, 

 

I am studying for an exam I am struggling with using a Vlookup. I have attached the instructions that were given to me to complete this assignment. I completely stuck and any help would be appreciated.

Thanks!

PracticeScreenshot.pngScreenshot 2.pngScreenshot3.pngScreenshot4.png

1 Reply

@Deleted 

 

Hi

You need to create a VLOOKUP (without any nesting) using an "Approximate" match, which means the last argument of the VLOOKUP (Range Lookup) should be either TRUE or 1

Unfortunately you did not send a file to do it for you

Good Luck

Nabil Mourad

Related Conversations