hello i have had some help over the past few days but i just cant get the last bit to work.
my aim is to get rid of all the #N/A errors when cells are empty.
right both codes do what i want them to do fine, code 2 looks at A26 to see if the cell is blank, if it is how ever it dose it it beyond me thats why im asking for help it dosent display the #N/a error the sheet is clean looking.
can someone change the first code so when the main cell is blank it dosent display the #N/A error
the only difference between the two codes are code 1 is looking at two refference sheets, and code2 is only looking at 1
thanks jason
does that make sence??????????
Code:
=IF(ISNA(VLOOKUP($A$31,'Line 3 Cat - Export Dog'!$A$22:$I$45,3,FALSE)),VLOOKUP($A$31,'Line 3'!A30:I81,3,FALSE),VLOOKUP($A$31,'Line 3 Cat - Export Dog'!$A$22:$I$45,3,FALSE))
Code:
=IF(ISBLANK(A26),"",VLOOKUP(A26,'Line 2'!$A$19:$I$28,3,FALSE))
my aim is to get rid of all the #N/A errors when cells are empty.
right both codes do what i want them to do fine, code 2 looks at A26 to see if the cell is blank, if it is how ever it dose it it beyond me thats why im asking for help it dosent display the #N/a error the sheet is clean looking.
can someone change the first code so when the main cell is blank it dosent display the #N/A error
the only difference between the two codes are code 1 is looking at two refference sheets, and code2 is only looking at 1
thanks jason
does that make sence??????????