Forum Discussion
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 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
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
