Hi Guys,
Guys am stuck here and require some assistance.
Ok, I have a Vlookup with is ISNA,(below) which works fine, what I want it do is increment the value of the error.
So where i see "Error1" is should move to Error2 if it finds the next error in the match, it should auto increment the value moving forward, I know it can be done, since I had seen somewhere in my previous one, but just couldn't think of it in this cold weather i guess. Kindly suggest the ideas...
=IF(ISNA(VLOOKUP(A3,'LBH All Permits'!A3:G739,6,FALSE)),"Error1",VLOOKUP(A3,'LBH All Permits'!A3:G739,6,FALSE))
Guys am stuck here and require some assistance.
Ok, I have a Vlookup with is ISNA,(below) which works fine, what I want it do is increment the value of the error.
So where i see "Error1" is should move to Error2 if it finds the next error in the match, it should auto increment the value moving forward, I know it can be done, since I had seen somewhere in my previous one, but just couldn't think of it in this cold weather i guess. Kindly suggest the ideas...
=IF(ISNA(VLOOKUP(A3,'LBH All Permits'!A3:G739,6,FALSE)),"Error1",VLOOKUP(A3,'LBH All Permits'!A3:G739,6,FALSE))