"Moh" wrote:
This is what i tried ... but it returns with #N/A
=LOOKUP(D5,{"Fusion","Openzone","Featureline 1 Year","Voip";15,35,5,78})

Think the lookup_vector** needs to be sorted in ascending order "A-Z",
viz. try it in D6 as:
=LOOKUP(D5,{"Featureline 1 Year","Fusion","Openzone","Voip";5,15,35,78})

**the part: {"Fusion","Openzone","Featureline 1 Year","Voip"; ...

But perhaps a less ambiguous way is to use vlookup with 4th param set to
zero/FALSE for an exact match (as suggested earlier).

Here's an adaptation which suits your context ..

In D6:
=IF(D5="","",VLOOKUP(D5,{"Fusion",15;"Openzone",35 ;"Featureline 1
Year",5;"Voip",78},2,0))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---