find specific number
I have one cell (B1) that I change according to a number between 1 and 45. I have a column of numbers (C1-C45) that do not change. Adjacent to column C1-C45 I have another column (D1-D45) of fractions in 1.01% - 9.99%. The formula I wish to create is, if the number in B1 is changed to 14 (example), then the number 14 is recognized in column C, in turn selecting the adjacent fraction in column D. Thank you for your consideration, Gary
Last edited by allgeef; 11-04-2011 at 06:53 AM.
Please attach an example that does not compromise your confidentiality.
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
hello
dummy workbooks are great help in solving certain problems.
Is this what you are expecting?
=lookup(B1,C$1:C$45,D$1:D$45)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
The lookup formula worked perfect. Thank you for taking time to assist. Regards, Gary
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks