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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies