"AndyS" skrev i en meddelelse
...
In need to us something similar to IF function but to have multiple
answers ie
if A3=5 then A5=$9
If A3=6 then A5=$12
IF A3=55 Then A5=$30
Any help would be greatly appreciated

Andy

One more way:

=INDEX({9,12,30},MATCH(A3,{5,6,55},0))


--
Best regards
Leo Heuser

Followup to newsgroup only please.