HOW TO CHANGE TEXT TO 1
Closed
GC
-
27 Aug 2009 à 08:53
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 27 Aug 2009 à 21:15
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 27 Aug 2009 à 21:15
Related:
- HOW TO CHANGE TEXT TO 1
- Tentacle locker 1 - Download - Adult games
- Igi 1 - Download - Shooters
- Fnia 1 apk - Download - Adult games
- How to change computer name - Guide
- How to change lg tv name - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
27 Aug 2009 à 21:15
27 Aug 2009 à 21:15
you must do the modification to your original formula
what is the formula which gives the N/A eerro
suppose the data from a1 to B4 are like this
a 1
s 2
d 3
f 4
in A8 you have "j"
in B8 if you have formula
=VLOOKUP(A8,$A$1:$B$4,2,0)
then B8 will get error that is #N/A
to avoid this you must have
=IF(ISNA(VLOOKUP(A8,$A$1:$B$4,2,0)),1,VLOOKUP(A8,$A$1:$B$4,2,0))
on these lines modify your macro
what is the formula which gives the N/A eerro
suppose the data from a1 to B4 are like this
a 1
s 2
d 3
f 4
in A8 you have "j"
in B8 if you have formula
=VLOOKUP(A8,$A$1:$B$4,2,0)
then B8 will get error that is #N/A
to avoid this you must have
=IF(ISNA(VLOOKUP(A8,$A$1:$B$4,2,0)),1,VLOOKUP(A8,$A$1:$B$4,2,0))
on these lines modify your macro
