Hello to all

I Enter My Vlookup Formula it give me #N/A Which is Right There is no
Problem with VLOOKUP Formula

Now i want to give Condition If there is any #N/A then i want a White Font
color Not Patten

I Try but could not get Success

Thanks in Advance

Hardeep Kanwar

us the formula isna....to check if there is any #ns error.

it would be like =isna(vlookup(....)) in the conditional format formula...

in place of dots put the vlookup formula that you using

--

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"Hardeep kanwar" wrote:

Hello to all

I Enter My Vlookup Formula it give me #N/A Which is Right There is no
Problem with VLOOKUP Formula

Now i want to give Condition If there is any #N/A then i want a White Font
color Not Patten

I Try but could not get Success

Thanks in Advance

Hardeep Kanwar

Thanks Satti Charvak

But I Already got the Answer

Thanks Again for your Valuable Suggestion

Hardeep kanwar

"Satti Charvak" wrote:

us the formula isna....to check if there is any #ns error.

it would be like =isna(vlookup(....)) in the conditional format formula...

in place of dots put the vlookup formula that you using

--

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"Hardeep kanwar" wrote:

Hello to all

I Enter My Vlookup Formula it give me #N/A Which is Right There is no
Problem with VLOOKUP Formula

Now i want to give Condition If there is any #N/A then i want a White Font
color Not Patten

I Try but could not get Success

Thanks in Advance

Hardeep Kanwar