#value returned instead of data

  • Thread starter Oscar of Issaquah Salmon Days Festival
  • Start date
O

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.
 
K

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))
 
O

Oscar of Issaquah Salmon Days Festival

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

Kevin Vaughn

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