Results 1 to 4 of 4

find specific number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-15-2010
    Location
    Oklahoma
    MS-Off Ver
    Excel 2019
    Posts
    168

    Question 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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1