Way to go Joel. Thankyou very much for your assistance.
Youv've made it sound so simple,and it works
"You've just lightened a heavy load!"
Kind regards
FG


"Joel" wrote:

if(ISNA(VLOOKUP(A1,sheet4!A1:c300,2,0)),"",VLOOKUP (A1,sheet4!A1:c300,2,0))

the first VLOKKUP is used to test if you get a NA. It is inside the ISNA().
The "" is if it does find the NA then print nothing. The second VLOOKUP
returns the value when there isn't a NA.

"Finance Guru" wrote:

Hi Joel - Thanks for a FAST response.
I don't quite undestand the the reason for the second Vllookup() , or what
should go into the quotes.

My VLOOKUP() looks like this - VLOOKUP(A1,sheet4!A1:c300,2,0). Am i not
able to adapt this in some way,to display a blank cell wher the criteria is
not met.

I hope you can help.
Thanks again


"Joel" wrote:

=if(isNA(Vllookup()),"",Vllookup())

"Finance Guru" wrote:

Can someone please advise me ; if VLOOKUP( ) doesn't find the result in the
formula,the the cell shows #NA. How can I get a cell to be blank,if the
value isn't found.

I have only just started using VLOOKUP & HLOOKUP,so any help would be
greatfully accepted. Thanks