Home |
Search |
Today's Posts |
#1
|
|||
|
|||
to many 'IF's'??
hi all, my problem is this. i have a worksheet(called master) with a drop down list in a cell.(C1) there are about 30 golf courses in this list. what i want to do, is that when i select a golf course in the list and it is then in cell C1, i need all of that golf courses details(par,stroke index and yardage) to appear on the the master worksheet automatically. all the required details are in a seperate workbook. i thought i had it cracked using the 'IF' function, but when i got to 7 or 8 'IF's' in the formula(for each course) it would not let me do anymore. is there an alternative way to do what i want, and if so an example would be greatly appreciated. many thanks, Boufant. -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=382971 |
#2
|
|||
|
|||
On Tue, 28 Jun 2005 18:01:27 -0500, boufant
wrote: hi all, my problem is this. i have a worksheet(called master) with a drop down list in a cell.(C1) there are about 30 golf courses in this list. what i want to do, is that when i select a golf course in the list and it is then in cell C1, i need all of that golf courses details(par,stroke index and yardage) to appear on the the master worksheet automatically. all the required details are in a seperate workbook. i thought i had it cracked using the 'IF' function, but when i got to 7 or 8 'IF's' in the formula(for each course) it would not let me do anymore. is there an alternative way to do what i want, and if so an example would be greatly appreciated. many thanks, Boufant. VLOOKUP should do what you want. --ron |
#3
|
|||
|
|||
Vlookup would be a much cleaner solution than nested If's. If you need help with
vlookup, post back. -- Regards, Fred Please reply to newsgroup, not e-mail "boufant" wrote in message ... hi all, my problem is this. i have a worksheet(called master) with a drop down list in a cell.(C1) there are about 30 golf courses in this list. what i want to do, is that when i select a golf course in the list and it is then in cell C1, i need all of that golf courses details(par,stroke index and yardage) to appear on the the master worksheet automatically. all the required details are in a seperate workbook. i thought i had it cracked using the 'IF' function, but when i got to 7 or 8 'IF's' in the formula(for each course) it would not let me do anymore. is there an alternative way to do what i want, and if so an example would be greatly appreciated. many thanks, Boufant. -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=382971 |
#4
|
|||
|
|||
Hi. Here's a sample workbook:
http://www.myexpertsonline.com/freedls/pricelist.xls And here's the Dropdown instructions: http://www.officearticles.com/excel/...soft_excel.htm And here's the Vlookup instructions: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "boufant" wrote in message ... hi all, my problem is this. i have a worksheet(called master) with a drop down list in a cell.(C1) there are about 30 golf courses in this list. what i want to do, is that when i select a golf course in the list and it is then in cell C1, i need all of that golf courses details(par,stroke index and yardage) to appear on the the master worksheet automatically. all the required details are in a seperate workbook. i thought i had it cracked using the 'IF' function, but when i got to 7 or 8 'IF's' in the formula(for each course) it would not let me do anymore. is there an alternative way to do what i want, and if so an example would be greatly appreciated. many thanks, Boufant. -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=382971 |
#5
|
|||
|
|||
thanks guys, the vlookup did the trick. boufant. -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=382971 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|