Using OR function with VLOOKUP

[tobes21]

I was wondering if it is possible to do a VLOOKUP where the lookup_value can be more than one value. I tried using an OR function but that didnt seem to work. I would like the VLOOKUP function to work for any of the values of text "M", "SC", "SH", "ODC". Here is my formula:

=VLOOKUP(OR("M","SC","SH","ODC"),'Cost Detail'!$D6:$G45,3,FALSE)

 

[tobes21]

It says I can't execute the code in break mode. So I guess I can't post the actual exel part.