|
-
Mar 1st, 2006, 05:27 AM
#1
Thread Starter
Hyperactive Member
 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
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
|
Click Here to Expand Forum to Full Width
|
Reply With Quote