Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Automatically enter text in cell based on another cell

  1. #1
    Join Date
    17th July 2013
    Posts
    7

    Automatically enter text in cell based on another cell

    Hi,
    I am trying to enter a value in a cell which is dependent on a corresponding value in a table. I have a table A which has a cab type and a corresponding cab number.
    What I want to achieve is that when I enter the cab number in another table say in cell (D3), the cab type is automatically entered in cell (C3).
    Please help.
    Table A
    Cab Type Cab No
    Indigo 100
    Indigo 758
    Innova 1544
    Indica 1675
    Indica 1676
    Innova 1919
    Innova 2070
    Indigo 2102
    Innova 2776
    Indica 2877
    Indica 2890
    Indica 2892
    Indica 3189
    Indigo 3250
    Indica 3364
    Indica 3552
    Indica 3554
    Indigo 4300
    Indigo 4301
    Indica 4321
    Indica 6040
    Indica 6140
    Indica 6300
    Indica 7060
    Indica 7061
    Indica 9802
    Indica 9922
    Thanks,

    UPU 3217

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st September 2010
    Posts
    7,921

    Re: Automatically enter text in cell based on another cell

    Swap the order of the columns and use a VLOOKUP formula...

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 4
    Last Post: May 29th, 2013, 07:59
  2. Replies: 5
    Last Post: March 11th, 2013, 23:38
  3. Replies: 19
    Last Post: February 2nd, 2011, 23:27
  4. Replies: 3
    Last Post: July 10th, 2006, 19:08
  5. Replies: 1
    Last Post: June 10th, 2004, 18:36

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
  •  
porno