Depending on your situation, you may be able to use one of the more
typical "workarounds".....a lookup table.
Example:
If you want your formula to return a department name based on its
DeptID, as in ...
IF A1=101, Return "A/R"
IF A1=102, Return "Shipping"
IF A1=103, Return "Maintenance"
IF A1=104, Return "Finance"
IF A1=105, Return "Security"
IF A1=106, Return "Tax"
IF A1=107, Return "Systems"
IF A1=108, Return "Treasury"
IF A1=109, Return "Admin"
You'd create a list (probably on another worksheet, say Sheet2) like
this:
ROW____COL_A_________COL_B
1_______101___________A/R
2_______102___________Shipping
3_______103___________Maintenance
4_______104___________Finance
5_______105___________Security
6_______106___________Tax
7_______107___________Systems
8_______108___________Treasury
9_______109___________Admin
Now, on Sheet 1:
A1: 106
B1: =VLOOKUP(A1,Sheet2!A1:B9,2,0)
(returns the value that corresponds to DeptID 106--Tax)
Something you could use? Or is your situation more complicated?
Regards,
Ron
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=487455