#value returned instead of data

[Oscar of Issaquah Salmon Days Festival]

My formula:
=IF(ISERROR(MATCH(K494,WWP_Installs!C$2:C$490,0)),"Unk",WWP_Installs!K$2:K$490)

K494 = 1980A 18th AVE NE
WWP_Installs!C$2:C$490 = 1980A 18th AVE NE
WWP_Installs!K$2:K$490 = 256M/64K

But result of formula is #VALUE

when performing calculationsteps, it say the cell (K494) contains a constant.

[Kevin Vaughn]

Not sure why you are getting #VALUE error, but I think you want something
like the following formula (note: I changed K494 to F15 for testing purposes)

=IF(ISERROR(MATCH(F15,WWP_Installs!C$9:C$490,0)),"Unk",INDEX(WWP_Installs!K$9:K$490,MATCH(F15,WWP_Installs!C$9:C$490,0),0))
--
Kevin Vaughn


"Oscar of Issaquah Salmon Days Festival" wrote:

> My formula:
> =IF(ISERROR(MATCH(K494,WWP_Installs!C$2:C$490,0)),"Unk",WWP_Installs!K$2:K$490)
>
> K494 = 1980A 18th AVE NE
> WWP_Installs!C$2:C$490 = 1980A 18th AVE NE
> WWP_Installs!K$2:K$490 = 256M/64K
>
> But result of formula is #VALUE
>
> when performing calculationsteps, it say the cell (K494) contains a constant.

[Oscar of Issaquah Salmon Days Festival]

Thanks Kevin, it worked but only after I used the correct column!! Appreciate
the help.


"Kevin Vaughn" wrote:

> Not sure why you are getting #VALUE error, but I think you want something
> like the following formula (note: I changed K494 to F15 for testing purposes)
>
> =IF(ISERROR(MATCH(F15,WWP_Installs!C$9:C$490,0)),"Unk",INDEX(WWP_Installs!K$9:K$490,MATCH(F15,WWP_Installs!C$9:C$490,0),0))
> --
> Kevin Vaughn
>
>
> "Oscar of Issaquah Salmon Days Festival" wrote:
>
> > My formula:
> > =IF(ISERROR(MATCH(K494,WWP_Installs!C$2:C$490,0)),"Unk",WWP_Installs!K$2:K$490)
> >
> > K494 = 1980A 18th AVE NE
> > WWP_Installs!C$2:C$490 = 1980A 18th AVE NE
> > WWP_Installs!K$2:K$490 = 256M/64K
> >
> > But result of formula is #VALUE
> >
> > when performing calculationsteps, it say the cell (K494) contains a constant.

[Kevin Vaughn]

You're welcome. I did that once but discovered I had used the wrong row
(after posting for assistance.)
--
Kevin Vaughn


"Oscar of Issaquah Salmon Days Festival" wrote:

> Thanks Kevin, it worked but only after I used the correct column!! Appreciate
> the help.
>
>
> "Kevin Vaughn" wrote:
>
> > Not sure why you are getting #VALUE error, but I think you want something
> > like the following formula (note: I changed K494 to F15 for testing purposes)
> >
> > =IF(ISERROR(MATCH(F15,WWP_Installs!C$9:C$490,0)),"Unk",INDEX(WWP_Installs!K$9:K$490,MATCH(F15,WWP_Installs!C$9:C$490,0),0))
> > --
> > Kevin Vaughn
> >
> >
> > "Oscar of Issaquah Salmon Days Festival" wrote:
> >
> > > My formula:
> > > =IF(ISERROR(MATCH(K494,WWP_Installs!C$2:C$490,0)),"Unk",WWP_Installs!K$2:K$490)
> > >
> > > K494 = 1980A 18th AVE NE
> > > WWP_Installs!C$2:C$490 = 1980A 18th AVE NE
> > > WWP_Installs!K$2:K$490 = 256M/64K
> > >
> > > But result of formula is #VALUE
> > >
> > > when performing calculationsteps, it say the cell (K494) contains a constant.