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

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


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=522635