vlookup query

[j4ymf]

hello folks

i was wondering if someone could give us a hand please

ive got this query
=VLOOKUP($A$4,'Line 1 '!$A$19:$K$59,5,FALSE)

$A$4 =xyz and the ,5, = 123 = result 123

the query works fine and does what i need it to do, but i want to make my sheet look pretty when the is nothing in A4

so if i have got xyz in A4, my result will be 123
if i have an empty cell in A4 i get #N/A


can i use conditional formatting with white text or somthing like that so it dosent show anything until somthing is in cellA4 ??????????
do you get what i mean


many thanks jason

 

[VoG]

Try (untested!)

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

 

[j4ymf]

fantastic thankyou