Results 1 to 2 of 2

Thread: Excel Function Problem (Urgent) [RESOLVED]

  1. #1

    Thread Starter
    Hyperactive Member boku's Avatar
    Join Date
    Dec 2004
    Posts
    386

    Exclamation Excel Function Problem (Urgent) [RESOLVED]

    I have 2 sheets, one (Source) with data on about 30R x 400C.

    On the second sheet (Results), I have copied the first two columns of sheet one (Source) using vlookup, now what I’m trying to do is enter a function in another cell (C2) on the second sheet (Results) that looks at both (A2 and B2), compares them to the first cells (A2 and B2) in the first sheet (Source) and returns the value of another cell (N2) in sheet one (Source)

    Source

    ...|........A.............|..........B.............|........C.........|..............N.............. |
    1 |....AI PO #.........|.....Cus PO #.......|..Date Order..|....Qty Outstanding....|
    2 |.AI007-9###7....|.....22100691.......|...01/03/06...|...............15............|

    Results

    ...|........A.............|..........B.............|..........C..................|.....N..........|
    1 |....AI PO #.........|.....Cus PO #.......|....Qty Outstanding....|................|
    2 |.AI007-9###7....|.....22100691.......|..............................|................|
    Last edited by boku; Mar 1st, 2006 at 06:34 AM. Reason: Solved
    -BoKu-

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Excel Function Problem (Urgent) [RESOLVED]

    Is this really resolved?

    If so, what did you do? Others could benefit.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width