Need help with Excel !!!!

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
my name is Mila , I’m trying to do this: I have a list of golf courses {Sheet!B3:B100} with different rates {Sheet!C3:H101} so on the SHEET 2 I have a SURCH columns where if I tape the name of golf course it will give me all the rates (I used =VLOOKUP)
Now THE PROBLEMs ARE 1): if I make mistake in the name it gives me totally different rates!!!! :( What can I do to make sure it give’s expected numbers?
2): and if in SURCH Sheet, course name blank, all the columns have #N/A?????

PS: here is some pictures, if it can be helpful:
http://s293.photobucket.com/albums/mm70/milka999/

If someone has time to help me I would really appreciate!!! Thank you so much!!!!

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
In sheet 2 where you have to type t he golf course name you can have validation list of all the golf course. This will avoid typing the golf course name, instead you can choose for the download list. But if you make a mistake in choosing from the download list the same problem may occur.