vlookup - If no data return blank instead of N/A

[Confidentjohn]

Hello Im running a vlookup up across a range of data that changes each week,

So i have set some vlookups to run throughout possibly more rows than need.

The only problem is if one week there are no results the data pulled in stats N/A

Is there a way to replace the N/A with a blank field.

I have tried the following but it was reutning the term FALSE where there was data.

=ISERROR(VLOOKUP($A182,'Extracted Data A'!$A$7:$O$403,15,FALSE))

Has anyone got any advice

Cheers

 

[Kaps_mr2]

IF(ISNA(VLOOKUP($A182,'Extracted Data A'!$A$7:$O$403,15,FALSE)),"",VLOOKUP($A182,'Extracted Data A'!$A$7:$O$403,15,FALSE))

Thanks

Kaps

 

[VoG]

Try

=IF(ISNA(VLOOKUP($A182,'Extracted Data A'!$A$7:$O$403,15,FALSE)),"",VLOOKUP($A182,'Extracted Data A'!$A$7:$O$403,15,FALSE))