#1   Report Post  
Posted to microsoft.public.excel.programming
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUPS Marianne Excel Discussion (Misc queries) 4 August 1st 09 02:28 PM
vlookups lfrick Excel Worksheet Functions 3 July 17th 09 10:03 PM
2 VLookups Guitarbuyer Excel Worksheet Functions 1 August 4th 08 09:45 PM
Dependent vlookups - nested vlookups (maybe) Maniv Excel Worksheet Functions 1 April 22nd 08 07:40 PM
Vlookups Shaya M Excel Discussion (Misc queries) 3 May 27th 05 07:17 AM


All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"