Hi Tony,

For this sort of thing, you'd be better of using a lookup table in
conjunction with one of Excel's lookup functions - LOOKUP, VLOOKUP or
HLOOKUP.

Cheers

--
macropod
[MVP - Microsoft Word]


"tonyk" wrote in
message ...

trying to use IF formula on column A1:A10 "office supplies" , "janitor
supplies" etc. On column D1:D10 needs to be corresponding codes from
A1:A10. I have tried IF(A1:A10="office supplies",D1:D10=6999) it will
work but A1:A10 are not always office supplies. How do i add more items
to correspond to their own codes? What should i type in Value_if_false?
Should I be use formula IF at all?
Here is the formula IF(A1:A10="office supplies",6999)


--
tonyk
------------------------------------------------------------------------
tonyk's Profile:
http://www.excelforum.com/member.php...o&userid=35088
View this thread: http://www.excelforum.com/showthread...hreadid=548482