Need help with Excel !!!!

Closed
Mila - Dec 30, 2009 at 05:51 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 1, 2010 at 04:50 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jan 1, 2010 at 04:50 AM
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.
0