+ Reply to Thread
Results 1 to 3 of 3

Nested If with VLOOKUP's... I think!

  1. #1
    Tim C
    Guest

    Re: Nested If with VLOOKUP's... I think!

    Try:

    =IF(ISNA(VLOOKUP(A2,range,1,FALSE)),"No
    match",IF(AND(VLOOKUP(A2,range,2,FALSE)=B2,VLOOKUP(A2,range,3,FALSE)=C2),"No
    change","Salary change"))

    where "range" includes all three columns on worksheet B.

    Tim C

    "PeterManner" <[email protected]> wrote in message
    news:[email protected]...
    > Hi all,
    >
    > What I'm trying to do is check to see if a cell (A2) from worksheet A
    > is within a range from worksheet B. Then, if true, need to compare the
    > next two cells (B2,& C2) in worksheet A to see if they are the same as
    > the next two cells from the range in worksheet B. This is what I have
    > thus far:
    >
    > =IF(ISNA(VLOOKUP(A2,Range 1,1,FALSE)),"ID No
    > Match",IF(AND(ISNA(VLOOKUP(B2,Range 2,1,FALSE)),(ISNA(VLOOKUP(C2,Range
    > 3,1,FALSE)),(((AND(B2=B10,C2=C10)),"No Change","Salary Change")))
    >
    > The issue I'm having is, how do you compare the next two cells from the
    > row the first lookup found in worksheet B with row where the formula in
    > on in worksheet A?
    >
    > Any help is much appreciated.
    >
    > Gerry
    >




  2. #2
    PeterManner
    Guest

    Nested If with VLOOKUP's... I think!

    Hi all,

    What I'm trying to do is check to see if a cell (A2) from worksheet A
    is within a range from worksheet B. Then, if true, need to compare the
    next two cells (B2,& C2) in worksheet A to see if they are the same as
    the next two cells from the range in worksheet B. This is what I have
    thus far:

    =IF(ISNA(VLOOKUP(A2,Range 1,1,FALSE)),"ID No
    Match",IF(AND(ISNA(VLOOKUP(B2,Range 2,1,FALSE)),(ISNA(VLOOKUP(C2,Range
    3,1,FALSE)),(((AND(B2=B10,C2=C10)),"No Change","Salary Change")))

    The issue I'm having is, how do you compare the next two cells from the
    row the first lookup found in worksheet B with row where the formula in
    on in worksheet A?

    Any help is much appreciated.

    Gerry


  3. #3
    Tim C
    Guest

    Re: Nested If with VLOOKUP's... I think!

    Try:

    =IF(ISNA(VLOOKUP(A2,range,1,FALSE)),"No
    match",IF(AND(VLOOKUP(A2,range,2,FALSE)=B2,VLOOKUP(A2,range,3,FALSE)=C2),"No
    change","Salary change"))

    where "range" includes all three columns on worksheet B.

    Tim C

    "PeterManner" <[email protected]> wrote in message
    news:[email protected]...
    > Hi all,
    >
    > What I'm trying to do is check to see if a cell (A2) from worksheet A
    > is within a range from worksheet B. Then, if true, need to compare the
    > next two cells (B2,& C2) in worksheet A to see if they are the same as
    > the next two cells from the range in worksheet B. This is what I have
    > thus far:
    >
    > =IF(ISNA(VLOOKUP(A2,Range 1,1,FALSE)),"ID No
    > Match",IF(AND(ISNA(VLOOKUP(B2,Range 2,1,FALSE)),(ISNA(VLOOKUP(C2,Range
    > 3,1,FALSE)),(((AND(B2=B10,C2=C10)),"No Change","Salary Change")))
    >
    > The issue I'm having is, how do you compare the next two cells from the
    > row the first lookup found in worksheet B with row where the formula in
    > on in worksheet A?
    >
    > Any help is much appreciated.
    >
    > Gerry
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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