excel guys... need some assistance...

[dfarrales]

NOTE: i just adjusted what i was looking for in w/s 3... the revised version is below:Text

I can't seem to figure this one out. i tried all the different functions but maybe i'm doing it wrong. btw, this is on excel 2k...

1st worksheet: i have one column of check#'s and the next column w/ check amounts. this w/s is a list of outstanding checks as of 12/31/01.

2nd worksheet: one column of check#'sa and the next column w/ check amounts. this w/s is a list of checks cleared in the month of jan02.

3rd worksheet: i want this worksheet to show the results (in the same format as the previous w/s's) of some type of query that will list the checks not yet cleared. basically, the checks on ws1 that are NOT on ws2.

can anyone help?

thanks a bunch!
Deo

 

[CPA]

Have you tried a vlookup?

 

[dfarrales]

yes, but my results are coming up "#n/a" even if i know that a check from ws1 is on ws2. i think i might be doing it wrong but the help menu isn't helping me.

deo

 

[CPA]

Yeah, vlookup can be touchy. make sure your columns are formatted the same and that your ranges are correct. what does your vlookup formula look like?

 

[NeoV]

pm me and I'll walk you through it...

if you are getting N/A's, then Excel can't find the same check# in the second file.....make sure that one isn't text and the other is a number, and vice versa...even spaces at the end of a text string can make a difference....

 

[Broncho]

I'm guessing that you remembered that the table that you are looking the values up in has to be sorted, right? If its not sorted vlookup won't work. Something else to consider, you need to put dollar signs before the column and row names of the table you are looking at, otherwise it will shift down. ex: $A$2:$B$10 You might already have thought of this, but the same problem stumped me on a spreadsheet for a day or so.