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.

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_In stalls!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.

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_In stalls!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.

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_In stalls!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.