Results 1 to 17 of 17

How to modifyVLOOKUP,to show a lookup value with several different values from table array

Threaded View

Arty_1 How to modifyVLOOKUP,to show... 12-29-2014, 09:53 AM
mrice Re: How to modifyVLOOKUP,to... 12-29-2014, 12:20 PM
Arty_1 Re: How to modifyVLOOKUP,to... 12-30-2014, 01:22 AM
adhawan06 Re: How to modifyVLOOKUP,to... 12-30-2014, 05:20 AM
Arty_1 Re: How to modifyVLOOKUP,to... 01-11-2015, 02:44 PM
FlameRetired Re: How to modifyVLOOKUP,to... 01-11-2015, 07:13 PM
Arty_1 Re: How to modifyVLOOKUP,to... 01-20-2015, 04:20 PM
paulmacro Re: How to modifyVLOOKUP,to... 01-14-2015, 04:14 AM
newdoverman Re: How to modifyVLOOKUP,to... 01-20-2015, 05:02 PM
Arty_1 Re: How to modifyVLOOKUP,to... 01-21-2015, 01:58 AM
Bobsone Re: How to modifyVLOOKUP,to... 01-21-2015, 03:44 AM
Arty_1 Re: How to modifyVLOOKUP,to... 01-22-2015, 01:58 AM
paulmacro Re: How to modifyVLOOKUP,to... 01-22-2015, 04:57 AM
Bobsone Re: How to modifyVLOOKUP,to... 01-22-2015, 10:14 AM
Arty_1 Re: How to modifyVLOOKUP,to... 01-23-2015, 05:18 PM
  1. 12-29-2014, 09:53 AM #1
    Arty_1 is offline
    Forum Contributor
    Join Date
    05-01-2014
    Location
    RIX
    MS-Off Ver
    Excel 2003; 2007
    Posts
    114

    How to modifyVLOOKUP,to show a lookup value with several different values from table array

    Hi!

    The situation: One lookup value has several different values in the table array.

    The problem: Usualy the vlookup formula shows only the first lookup value from the table array.

    The question: How to modify the formula so that all the values from table array are shown, despite the particular lookup value is the same?

    See the file with more detailed info attached.Vlookup_modif.xls

    Thanks in advance!
    Last edited by Arty_1; 12-29-2014 at 09:57 AM.
    Regards

    Arty
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. LOOKUP TABLE -blank cell in the table array to return a figure
    By jonnops in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2014, 09:08 AM
  2. [SOLVED] Lookup question matching part of lookup value in the table array
    By kosmo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2013, 11:07 AM
  3. [SOLVED] Vlook up when duplicate values in the array table and lookup column
    By vinodt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2012, 10:28 PM
  4. [SOLVED] Returning an array of lookup values from an input array, rather than single value
    By jase250 in forum Excel General
    Replies: 19
    Last Post: 05-09-2012, 03:31 AM
  5. Using the values in an array to lookup a result in another array.
    By Windshear in forum Excel General
    Replies: 3
    Last Post: 11-02-2011, 07:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1