Results 1 to 5 of 5

Displaying text in a cell depending on the value entered

Threaded View

Rhiannon25 Displaying text in a cell... 01-29-2013, 02:49 AM
Fotis1991 Re: Displaying text in a cell... 01-29-2013, 03:11 AM
Rhiannon25 Re: Displaying text in a cell... 01-29-2013, 07:14 PM
Fotis1991 Re: Displaying text in a cell... 01-30-2013, 02:51 AM
Rhiannon25 Re: Displaying text in a cell... 01-30-2013, 07:21 PM
  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Western Australia, Australia
    MS-Off Ver
    Excel 2003
    Posts
    44

    Displaying text in a cell depending on the value entered

    Hi

    I have a spreadsheet (see attached) I want to be able to insert a number (from 1-5, which will represent how many inspections someone has completed in that week) in the cells coloured blue and depending on that value have the cell populate with one of the cells in column R.

    For example if I enter:
    1 = R4
    2 = R5
    3 = R6
    4 = R7
    5 = R8

    As for the purpose of this spreadsheet the ticks better diplay the data.

    Is there a formula that is able to do this?? (I would prefer a formula as I do not know how to use macros and I will need to take the formula from the spreadsheet I have provided onto the original copy.)

    Any help would be greatly appreciated
    Attached Files Attached Files

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