Lookup function help please
Many Thanks T. Valko
Colette
"T. Valko" wrote:
Remove all the quotes from around any numbers.
=IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
=IF(VC1="U",1,IF(VC1="Z",2,IF(VC1="E",3,IF(VC1="P" ,4))))
=LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
=LOOKUP(AU17,{1,2,3,4},{0.175,0,0,0.05})
Alternative to LOOKUP:
=CHOOSE(AU17,0.175,0,0,0.05)
--
Biff
Microsoft Excel MVP
"Colette" wrote in message
...
I'm trying to use the following LookUp function but it keeps on coming up
as
#N/A for option 1 but seems to work for 2,3 and 4, can someone tell me
where
I'm going wrong
=LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
The AU17 cell has the following formula in it, and it works - this is for
VAT
=IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
Many Thanks for your help
.
|