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
Bookmarks