|
I have a spreadsheet with with rows consisting of a unique string, and to the right of each of the rows is a number (a percentage to be exact). There's around 150 rows and 10 columns. I need to set up a formula that will search a string value that I input, find it in the data spreadsheet, then look across and compare the first value to another inputted value. If the inputted value is lower than the data value, the cell's column header at the top of the spreadsheet is returned to a cell near the input data. If the value is higher, the formula then checks the next value for the same test, and so forth, until either finding a value, or if it finds a null value (ie the end of the table), it returns a string like "INSUFFICIENT". The logic is simple but I'm not quite sure how to use excel to do this, will I need VBA script or can I just do a formula? LuckySevens fucked around with this message at 01:18 on Dec 16, 2009 |
# ¿ Dec 16, 2009 01:15 |
|
|
# ¿ May 7, 2024 02:03 |
|
nm I just cooked up a vba script
|
# ¿ Dec 16, 2009 10:04 |