Hi Friends,

I want to filter the value of "#N/A" in a particular column and apply vlookup formula on those cells only(Non Hear cells)

And every time the value "#N/A" appear in different cells hence it should be dynamic.

Example i need to apply filter "#N/A" in column "N" and apply vlook up to get values only for "#N/A" cells.

Regards,

Prabhu