Results 1 to 4 of 4

Nested IF/OR with VLOOKUP

Threaded View

alisapooh Nested IF/OR with VLOOKUP 09-24-2009, 12:30 PM
NBVC Re: Nested IF/OR with VLOOKUP 09-24-2009, 12:35 PM
Paul Re: Nested IF/OR with VLOOKUP 09-24-2009, 12:38 PM
alisapooh Re: Nested IF/OR with VLOOKUP 09-24-2009, 12:54 PM
  1. #1
    Registered User
    Join Date
    09-21-2009
    Location
    AZ
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    12

    Thumbs up Nested IF/OR with VLOOKUP

    I'm trying to build this formula and I'm only half way through it and it already isn't working.

    Column D - can be 1, 2, 3, or 4
    Column E - can be any number

    If column D is 1 or 3, then the VLOOKUP should look up column E and point to the answer in column 4 on another worksheet (Companies in this case).

    If column D is 2 or 5, then the VLOOKUP should look up column E and point to the answer in column 5 on another worksheet (Companies in this case)..

    This is what I have so far, just trying to get it to recognize if it is a 1 or 2:

    =IF(OR(D2=1,VLOOKUP(E2,Companies!A:G,4)),IF(D2=2,VLOOKUP(E2,Companies!A:G,5)))

    What is making this not work? I'm getting a false. But before I added the OR, it worked for the D2=1.

    Thanks.

    Alisa

    Last edited by alisapooh; 09-24-2009 at 12:54 PM.

Thread Information

Users Browsing this Thread

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

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