VLOOKUP #REF ERROR

Copper 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

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