Home

VLOOKUP #REF ERROR

%3CLINGO-SUB%20id%3D%22lingo-sub-738911%22%20slang%3D%22en-US%22%3EVLOOKUP%20%23REF%20ERROR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738911%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20can't%20seem%20to%20understand%20why%20I%20am%20getting%20a%20ref%20error%20for%20my%20vlookup%20formula%2C%20I%20would%20greatly%20appreciate%20any%20help!!%3C%2FP%3E%3COL%3E%3CLI%3EIn%20cell%20Q4%2C%20enter%20a%20formula%20using%20the%20%3CSTRONG%3EVLOOKUP%3C%2FSTRONG%3E%20function%20to%20display%20a%20staff%20member%E2%80%99s%20pay%20rate.%20Look%20up%20the%20employee%20ID%20listed%20in%20cell%20%3CSTRONG%3EQ2%3C%2FSTRONG%3E.%20Use%20a%20structured%20reference%20to%20retrieve%20the%20value%20in%20the%205th%20column%20of%20the%20%3CSTRONG%3EStaff%20%3C%2FSTRONG%3ESince%20the%20formula%20is%20looking%20for%20a%20specific%20staff%20member%E2%80%99s%20data%2C%20find%20an%20exact%20match.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738911%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738931%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20%23REF%20ERROR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738931%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20that%20resolved%20the%20issue!%20I%20really%20appreciate%20your%20help!!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738917%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20%23REF%20ERROR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738917%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F371389%22%20target%3D%22_blank%22%3E%40ElsaRobles%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EYou%20have%20an%20issue%20with%20the%20second%20argument%20of%20the%20VLOOKUP%20function.%3C%2FP%3E%3CP%3Eif%20you%20replace%20it%20with%20the%20entire%20table%20%2C%20named%20Staff%2C%20it%20will%20work%20fine%20(presently%20you%20are%20selecting%20one%20column%20only)%3C%2FP%3E%3CP%3E%3DVLOOKUP(Q2%2CStaff%2C5%2C0)%3C%2FP%3E%3CP%3EFalse%20%3D%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
ElsaRobles
New Contributor

Hi, I can't seem to understand why I am getting a ref error for my vlookup formula, I would greatly appreciate any help!!

  1. In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s pay rate. Look up the employee ID listed in cell Q2. Use a structured reference to retrieve the value in the 5th column of the Staff Since the formula is looking for a specific staff member’s data, find an exact match.
2 Replies

@ElsaRobles 

Hi,

You have an issue with the second argument of the VLOOKUP function.

if you replace it with the entire table , named Staff, it will work fine (presently you are selecting one column only)

=VLOOKUP(Q2,Staff,5,0)

False = 0

 

Hope that helps

Nabil Mourad

Highlighted

Yes that resolved the issue! I really appreciate your help!! @nabilmourad 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies