Forum Discussion

Copper Contributor

Jul 05, 2019

VLOOKUP #REF ERROR

Hi, I can't seem to understand why I am getting a ref error for my vlookup formula, I would greatly appreciate any help!! In cell Q4, enter a formula using the VLOOKUP function to display a staff m...

NP_EX16_8b_PalomaPedraza Robles_2.xlsx35 KB

excel

Excel on Mac

Formulas and Functions

nabilmourad

MVP

Jul 05, 2019

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

ElsaRobles
Copper Contributor
Jul 05, 2019
Yes that resolved the issue! I really appreciate your help!! nabilmourad