help need to change a query!

[j4ymf]

hello i have had some help over the past few days but i just cant get the last bit to work.

=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))

=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??????????

 

[j4ymf]

sorry i forgot i posted somthing on the same lines last night but it has been sorted now thanks


result!!

=IF(ISBLANK(A31),"",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)))