G
Guest
In Sheet1 I have the following formula in B149:
=IF(VLOOKUP(A149,MyClinics,3,FALSE),"Yes","No")
MyClinics is a named range on my sheet - Reference List
In My Define Ranges Dialog Box I have:
MyClinics with RefersTo: as:
='Reference List'!$A$115:$E$222
What are the other possibilities as to why I'm getting
nothing but #N/A returned?
TIA,,,
=IF(VLOOKUP(A149,MyClinics,3,FALSE),"Yes","No")
MyClinics is a named range on my sheet - Reference List
In My Define Ranges Dialog Box I have:
MyClinics with RefersTo: as:
='Reference List'!$A$115:$E$222
What are the other possibilities as to why I'm getting
nothing but #N/A returned?
TIA,,,