Need a smaller Formula than below: Home Board Archive Index Excel Formulas Need a smaller Formula than below: Posted by Nick White, N.Carolina on January 04, 2002 6:51 AM ERR Posted by Scott on January 04, 2002 7:12 AM You can make a table, and then refer to it with a VLOOKUP Posted by John on January 04, 2002 7:44 AM How about:=OFFSET(firestone_product_pricing!$A$2,$A$8,0)