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.......|..............................|................|
Re: Excel Function Problem (Urgent) [RESOLVED]
Is this really resolved?
If so, what did you do? Others could benefit.