Vlookup Problem!?

N

Neo1

Hello I have a slight problem creating a vlookup, I've done a list of
Hotels and beside that cell i want to create a Vlookup so that if its
Hotel * then it displays £50, Hotel ** £70

Ive created the list but the problem is They all start with the same
name which is 'Hotel' but with different number of stars, I'm guessing
vlookup doesnt recognise the star character and just takes it into
account that they are all the same, thus displays the same price.


Thanks
From John
 
B

Bob Phillips

* is a wildcard character, so use ~* to lookup

=VLOOKUP("Hotel ~*~*",L7:N10,2,FALSE)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

davesexcel

=LOOKUP(C14,A14:B16)
Excel Recognizes:
Hotel *
Hotel **
Hotel ***
C1 is the criteria
The other is the range of the two columns
Lookup function is only good for 2 columns, after that you need VLOOKUP
 
N

Neo1

I cant get what you posted, basically I'm trying to do that following:

I a drop down list with the following hotels:

Hotel *
Hotel **
Hotel ***
Hotel ****

and then beside that drop down list cell i have a vlookup which is like
this

=VLOOKUP(A1,M20:N27,2,false)

But obviously it doesnt work since excel doesnt recognise the * it only
recognises the name which is hotel and since they are all the same it
displays the same price which that isnt the case in my list of Hotels
and prices...how can i deal with this problem...could i use another
sort of star or....?


Thanks for your time
From John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup problem.. 5
vlookup 4
Vlookup and Indirect help!! 2
Vlookup 2
VLOOKUP problem 3
help - problem with data using vlookup in Excel 2003 1
PLEASE HELP - COPY VLOOKUP 6
VLOOKUP and cell color problem. 1

Top