Thread: Vlookups
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wendy[_3_] Wendy[_3_] is offline
external usenet poster
 
Posts: 11
Default Vlookups

can you use Like statements for Vlookups??

I'm am trying to do this...

If it's Interior or 20 Min * then column 1
elseif Exterior then column 2
elseif 45 Min/60Min/90 min then Colum 3

20 min/45/60/90 they will all say 20 Min..but after that's it can 1 of 2
choices..I just didnt' want to write it all out...wanted to just say if it's
like 20 MIN * then...

Can it be done?

Thanks