mercredi 7 août 2019

excel formula if number then vlookup to get text associated in row

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