Jul 04 2019 07:21 PM
Hi, I can't seem to understand why I am getting a ref error for my vlookup formula, I would greatly appreciate any help!!
Jul 04 2019 07:44 PM
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
Jul 04 2019 08:51 PM
Yes that resolved the issue! I really appreciate your help!! @nabilmourad