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
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