#NA how to remove

Hi

I have the following formula

Please Login or Register  to view this content.

How do you stop the #NA appearing. I'd prefer it to show nothing "" if possible.

thanks

Hi there,

As your using Excel 2007, you can make use of the IFERROR function that was introduced with that version of Excel, i.e.

=IFERROR(VLOOKUP(H2,Sessions_2012!A:C,2,0),"")

HTH

Robert

thankyou - problem solved

You're welcome