Simple(?) lookup

Hi!
Im new here and found this to be an excellent forum.

My problem is this, i use this formula:

=IF(ISERROR(LOOKUP(A11;Sprit;SystemPrice));"-";LOOKUP(A11;Sprit;SystemPrice))

Where "Sprit" is Sheet3!A1:A184 and SystemPrice is Sheet3!B1:B184.
A11 is a cell with a dropdownlist which chooses Names from the list Sprit.

The thing is that everything seem to be working, but every other printout is incorrect. Like it picks data wrong from the Array SystemPrice. When I check the array in Name Manager, everything is in the right order.

Is this some kind of bug in Excel 2007, or am I doing something wrong? This should be pretty easy and straightforward, now shouldnt it?

Hmm. I found this now:
"The values in lookup_vector must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase and lowercase text are equivalent."

My list isnt like that, and it cant be arranged like that. Is there any other possible way to do this?

Try

=IF(ISNA(MATCH(A11;Sprit;0));"-";INDEX(SystemPrice;MATCH(A11;Sprit;0)))

assuming Sprit and System Price are both equal sized columns (or rows)

Thank you for the fast reply!

It worked perfectly.

Thank you!!!