help need to change a query!

j4ymf

Well-known Member
Joined
Apr 28, 2003
Messages
607
Office Version
  1. 365
Platform
  1. Windows
hello i have had some help over the past few days but i just cant get the last bit to work.

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

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

j4ymf

Well-known Member
Joined
Apr 28, 2003
Messages
607
Office Version
  1. 365
Platform
  1. Windows
sorry i forgot i posted somthing on the same lines last night but it has been sorted now thanks


result!!
Code:
=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)))
 

Watch MrExcel Video

Forum statistics

Threads
1,113,848
Messages
5,544,640
Members
410,627
Latest member
georgealice
Top