Hi,
I believe it is possible, but i cannot work out how to do it!
What im wanting to achieve is to have two drop down boxes reading from a table. Ie one dropdown box will read the x axis and the other will read the y axis and result the data from the table been shown in a seperate cell. Its hard to explain but pretty simple if you look at the example sheet i have uploaded.
I would very much appreciate anyones help!!
Try:
=INDEX(B13:F17,MATCH(B3,TILT,0),MATCH(B4,ORIENTATION,0))
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi d3ell,
Try
see attached.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
check attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Re: Drop down box to read data from a table?
Works a treat!!
Thanks Guys! - you make it look easy!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks