I wrote a formula to be able to change a part number based on the color
and length of a part. The color cell (always located at K14) and the
part length (E16 below but changes) in the formula change when I copy
to a new cell. How can I get it to change only the part length cell
but not the color cell when I copy to a new cell? (hope that's not too
confusing)

=IF((K14="TUDOR BROWN"),VLOOKUP(E16,TBROWN,2),IF((K14="SPANISH
CLAY"),VLOOKUP(E16,SCLAY,2),IF((K14="OCEAN
BLUE"),VLOOKUP(E16,OBLUE,2),IF((K14="SLATE
GRAY"),VLOOKUP(E16,SGRAY,2),IF((K14="REGAL
RED"),VLOOKUP(E16,RRED,2),IF((K14="CLASSIC
GREEN"),VLOOKUP(E16,CGREEN,2)))))))

Thanks.



--
Jettero2112
------------------------------------------------------------------------
Jettero2112's Profile: http://www.excelforum.com/member.php...o&userid=16622
View this thread: http://www.excelforum.com/showthread...hreadid=314875