Results 1 to 17 of 17

Using multiple cells in VLOOKUP function for lookup_value - possible?

Threaded View

Vitalite Using multiple cells in... 08-05-2017, 05:05 AM
AliGW Re: Using multiple cells in... 08-05-2017, 05:19 AM
AliGW Re: Using multiple cells in... 08-05-2017, 06:08 AM
Vitalite Re: Using multiple cells in... 08-05-2017, 06:54 AM
AliGW Re: Using multiple cells in... 08-05-2017, 07:14 AM
Vitalite Re: Using multiple cells in... 08-05-2017, 07:22 AM
JohnTopley Re: Using multiple cells in... 08-05-2017, 07:38 AM
Vitalite Re: Using multiple cells in... 08-05-2017, 09:40 AM
AliGW Re: Using multiple cells in... 08-05-2017, 07:39 AM
Vitalite Re: Using multiple cells in... 08-05-2017, 09:00 AM
AliGW Re: Using multiple cells in... 08-05-2017, 09:04 AM
Vitalite Re: Using multiple cells in... 08-05-2017, 09:28 AM
JohnTopley Re: Using multiple cells in... 08-05-2017, 09:53 AM
Vitalite Re: Using multiple cells in... 08-05-2017, 10:10 AM
AliGW Re: Using multiple cells in... 08-05-2017, 10:22 AM
Vitalite Re: Using multiple cells in... 08-05-2017, 10:28 AM
AliGW Re: Using multiple cells in... 08-05-2017, 10:42 AM
  1. #1
    Forum Contributor
    Join Date
    05-20-2017
    Location
    Boston, US
    MS-Off Ver
    Mac 2011
    Posts
    139

    Using multiple cells in VLOOKUP function for lookup_value - possible?

    Hello!

    I have three consecutive columns (B,C,D) and cells in these columns are filled with values or are empty.
    Column J should display some text based on whether values in cells in columns G,H and I have certain values and those values correspond to a certain condition.

    For example, B2 = 343, C2 = 319, D2 = 200;
    my function should find these values in another sheet, check if the status is "done" for each of them, and put in J13 = "closed".

    For another example, some B6 = 342, C6 = 319, but D6 is empty now, therefore nothing should be displayed in cell J13.

    My basic formula that I am trying to expand is:

    Formula: copy to clipboard
    =IFERROR(IF(VLOOKUP(B2,sheet2!B2:C5,COLUMNS(sheet2!B2:C6),FALSE)="done", "Closed",""),"")


    I tried this:
    Formula: copy to clipboard
    =IFERROR(IF(VLOOKUP(AND(B2,C2,D2),sheet2!B2:C5,COLUMNS(sheet2!B2:C6),FALSE)="done", "Closed",""),"")


    but it is obviously incorrect as it doesn't check conditions for each cell, doesn't it?

    Please, help me to find a smart solution, preferably based on mathematical approach.
    Thank you very much!
    Attached Files Attached Files
    Last edited by Vitalite; 08-05-2017 at 07:05 AM. Reason: edited the file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help? vlookup multiple lookup_value is this possible?
    By freedert001 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2016, 01:50 AM
  2. using vlookup where lookup_value is a formula
    By foozbear in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-15-2015, 01:55 AM
  3. 2 lookup_Value for Vlookup
    By bryceismad1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2014, 02:06 PM
  4. [SOLVED] VLookup if lookup_value is not found
    By jndipworm in forum Excel General
    Replies: 4
    Last Post: 07-09-2012, 06:47 PM
  5. VLOOKUP won't take a formula for lookup_value???
    By scurveydog in forum Excel General
    Replies: 3
    Last Post: 10-05-2010, 05:21 PM
  6. lookup_value in VLOOKUP formula
    By 99f150 in forum Excel General
    Replies: 7
    Last Post: 03-16-2010, 11:21 AM
  7. vlookup:same lookup_value, different returns
    By javino in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2005, 09:00 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