hello everybody,
I have a value (6) in a cell and i want to look it up in a table
1 4
2 11
3 9
4 6
5 3
i want the program to look up 6 and then give the value 4 in another cell
how would one go about this
rugbyboy123
Dear all,
i am trying to create a table in excel spreadsheet which the userputs an input data, say 6( or any number ) and from that when they click on a macro button creates the given amount of rows i.e 6 and then the user can add another set of values i.e
how many pipe systems ( user inputs...
