I am trying to have an excel formula to check a column if it has a number, I want the text that is associated with it. I keep getting a “#N/A” and I’m having issues figuring out what I’m doing wrong. My formula: =vlookup(isnumber(N2),$N$1:$O$40,3,0)
N2 has a value of 500 Q2 has a text of January
The numbers in the N column are not always the same numbers. Thanks in advance!!
Aucun commentaire:
Enregistrer un commentaire