How do I reference a formula to a dropdown list
I had a table of data from which I created a drop-down list. I want to be
able to select the name of an item from the dropdown menu and then have the data inputed through a formula. The problem I'm having is that while only one row appears when I select the data from the drop-down, the rest are hidden so the row numbers for my formula are only correct once. (ie, formula uses cells B3 and C3, however when I select the next item from the list cells B4 and C4 contain the data I wish to input) |
How do I reference a formula to a dropdown list
show ur formula in validate list
remember u can only refers to 1 column a1:a5 <- is ok a1:b5 <- is not |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com