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