+ Reply to Thread
Results 1 to 5 of 5

Lookup and Fill

  1. #1
    Registered User
    Join Date
    03-28-2017
    Location
    US
    MS-Off Ver
    2010
    Posts
    38

    Lookup and Fill

    Hi,

    I need help with Lookup or any other option to look up data, and put another data to the cell.
    Please refer to the screen capture and excel file.

    Thank you
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,880

    Re: Lookup and Fill

    Try this in G3:

    =INDEX(B:B,MATCH(E3,A:A,0))

    or

    =VLOOKUP(E3,A:B,2,FALSE)

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,094

    Re: Lookup and Fill

    Or

    =LOOKUP(E3,$A$3:$B$12)

    You can never have too many options I guess
    HTH
    Regards, Jeff

  4. #4
    Registered User
    Join Date
    03-28-2017
    Location
    US
    MS-Off Ver
    2010
    Posts
    38

    Re: Lookup and Fill

    Thank you!!!!!!

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,094

    Re: Lookup and Fill

    You are very welcome and thanks for the feedback. We are happy to help!

+ 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. VBA code to lookup and fill across
    By ramananhrm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2016, 12:08 AM
  2. [SOLVED] lookup average and fill in table
    By burdo77 in forum Excel General
    Replies: 3
    Last Post: 08-12-2014, 04:02 AM
  3. Double lookup to fill an array
    By gvelix in forum Excel General
    Replies: 3
    Last Post: 12-11-2009, 09:15 AM
  4. horizontal lookup/fill
    By pfchang in forum Excel General
    Replies: 5
    Last Post: 10-29-2009, 05:41 PM
  5. Lookup/Fill-in form ?
    By Bob408SS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2008, 03:46 PM
  6. Lookup and Fill In
    By chconnol in forum Excel General
    Replies: 1
    Last Post: 05-13-2008, 01:14 PM
  7. Replies: 1
    Last Post: 01-06-2005, 09:06 PM

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