+ Reply to Thread
Results 1 to 2 of 2

IF Value is Entered, Text is Input

Hybrid View

therealsouthern IF Value is Entered, Text is... 05-18-2021, 10:06 AM
JohnTopley Re: IF Value is Entered, Text... 05-18-2021, 10:44 AM
  1. #1
    Registered User
    Join Date
    05-18-2021
    Location
    Orange Beach, AL
    MS-Off Ver
    2104
    Posts
    1

    Lightbulb IF Value is Entered, Text is Input

    Hey Team! I have taken over a spread sheet at work for my uncle's business expenses, my aunt has done a good job with data entry, a tad old school however. I know there's an easier way verses typing out a word a letting autofill do its thing, so here's my dilemma:

    Each category on a Schedule C has a line number and description.
    · 8 - Advertising
    · 9 - Car & Truck
    · 11: Contract Labor
    ...And so on and so forth.

    So what formula would I need to play so that when I type the number 8, it changes the value to Advertising?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,767

    Re: IF Value is Entered, Text is Input

    Perhaps VLOOKUP

    Create a table with (for example) the number in Column X and Description in Column Y

    If Line no is C2 and description is in D2

    in D2

    =VLOOKUP($C2,$X$2:$Y$20,2,FALSE) so your table is in range X2:Y20

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] once cell E1 is entered need input box for date to be populated in B1
    By mlski4751 in forum Excel General
    Replies: 4
    Last Post: 07-23-2014, 04:20 PM
  2. I want a input box to show * instead of text when info is entered
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-17-2013, 08:00 AM
  3. Copy value entered in Input Box to another location
    By staples in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2009, 06:29 AM
  4. Replies: 2
    Last Post: 04-25-2009, 04:19 AM
  5. auto input text in 'a' when text entered in 'b'
    By crizzle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-17-2008, 03:20 PM
  6. Input box appears with text entered...
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2007, 10:46 AM
  7. [SOLVED] Input Date when data is entered into another cell
    By GaryByrd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2005, 09:06 PM

Tags for this Thread

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