Why am I getting a #N/A??

[Korimint]

here is my formula:

if(vlookup(a26,d3:g36,4,0)=0,"","True")

What am I doing wrong not to get a blank instead of #N/A

 

[Dryver14]

try column 3 insted of 4 assuming the lookup value is column 1

 

[Dave Patton]

Did you Evaluate your formula step at a time or with Excel's Evaluate formula?

You may want to check Excel's Help for ISNA.

 

[Korimint]

I get the same issue, for some reason it keeps going back to the 0 as the problem.

 

[Aladin Akyurek]

here is my formula:

if(vlookup(a26,d3:g36,4,0)=0,"","True")

What am I doing wrong not to get a blank instead of #N/A

Testing a VLOOKUP result for being equal to 0 is okay as long as it does not return #N/A for #N/A = 0 is still #N/A.

By the way, care to describe what the formula is intended to do?

 

[CWatts]

The look up value and the value in the table are probably different formats. One of them is probably formatted as a number, while the other is formatted as text.

if you find a cell with a number of 1 (or make one). Copy it, and highlight all numbers, Paste Special > Multiply which will convert numbers stored as text to numbers.

If you haven't formatted the cells, text will also be left justified, while numbers will be right justified. Hope that helps!

 

[Korimint]

Thanks CWatts, that worked!!