ISNA Over Multiple Cells

[Arts]

Hi all

This is probably one of those questions where there is a simple solution but for what ever reason I am unable to find it.

If I have a #NA value over two cells and wanted to return the value so for the below I would use the formula =IF(ISNA(A1),B1,A1).

My question is, is there a way or a simpler way of bringing back a value over multiple cells rather than using a combination of IF Formulas?

Many thanks all!

 

[Arts]

Put this into a blank cell what does it return

=ISNUMBER(A2)

FALSE

 

[Sufiyan97]

it is returning an error from a vlookup

View attachment 57958

wrape your vlookup into

=IFERROR(VLOOKUP(E2,$K$3:$K$7,2,0),0)

 

[Sufiyan97]

FALSE

View attachment 57959

copy that into cell c2 then see the result

 

[Fluff]

You need to check A2 not A3

 

[Arts]

wrape your vlookup into

=IFERROR(VLOOKUP(E2,$K$3:$K$7,2,0),0)

That would return a zero I believe but with regards to the initial question of returning a value over rows that contain an #N/A I don't believe that will help?

 

[Fluff]

See post#14

 

[Arts]

You need to check A2 not A3

Apologies , A2 returns

 

[Fluff]

In that case this formula should work

=MAX(IFERROR(A2:C2,0))

 

[Arts]

In that case this formula should work

=MAX(IFERROR(A2:C2,0))

For what ever reason this still returns 0

 

[Fluff]

Try confirming it with Ctrl Shift Enter, rather than just Enter.