Formula Reference Error, HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The formula that follows works very well: =IF(C13="Horn",(A13),"")

What I'd like to do is have this formula reference a column range to say: =IF(C1:C61="Horn",(A1),""). take this record with "Horn", "Harber" or "Jet" as the product type as a marker/key and plug the whole record here! This, is where the error is generated. I'm close, I know, but, no cigars, yet! Can someone assist to resolve this?

Thanks,
 
Hi Syd

hope I understood you correctly:
- In Column C1:C61 you store identifiers/names (i assume you have
unique entries)
- In Column A you have associated values/information to transfer

Normaly I would use VLOOKUP bus as your identifier is not in the
leftmost column you can use a combination of MATCH and INDEX.
=INDEX(A1:C161,MATCH("Horn";C1:C161,0),1)
will return the value in column A where column C='Horn'

HTH
Frank
 
Back
Top