Hi all,
My question refers to below table.

A B C
1 - =vlookup(
3 - =vlookup(
6 NA =vlookup(
2 - =vlookup(................

In C column, I want to put vlookup formula for Column A data. But if cells in B column contains data "NA" then vlookup for that cell should be neglected.

Please help.

thanks in advance