Excel Question for Session Tracking

[jwp]

I am a novice Excel user and have created a spreadsheet to keep track of my sessions. (This is in addition to PokerTracker because PT does not deal with all the sites.) I have a Sheet for each site I play on with some basic data about the session: date, buy-in, net result, etc.

I am trying to create a "Totals" type of sheet that will net all of my activity for a single day. The problem I am having is that on different days, I play on diffeent sites, so when I attempt to do a LOOKUP for a certain day on a sheet/site where I have not played that day, it returns me an error. (I can modify the lookup command to return the data for the date nearest the date I am specifying, but that would produce erroneous data.) The question is: how can I get that LOOKUP to simply return a 0?

Any clue or snippet of a formula would be appreciated.

JWP

[TheNoocH]

post the formula you are using now for a start

[maryfield48]

How about an IF statement that checks if the Lookup returns a number, if so, return that number, else return 0.

[jwp]

Here is the formula that uses the date (cell A3) and looks for a data match on another sheet (e.g. PokerStars) for that particular day.
@VLOOKUP($A3,PokerStars,2,FALSE)

The problem is that if there is no data for the date in cell A3 on the Poker Stars sheet, the formula returns the error message #N/A.

Here is the formula that Excel suggests to turn the #N/A message into a 0, but then it is currently taking any of the good data that I have and giving me the #N/A error message

IF(ERROR.TYPE(B3)=7,0,B3)

Thanks,
JWP

[jwp]

My Excel knowledge lacks here. How would I perform an IF on the type of value to see if it's a number?

Thanks,
JWP

[rhizome]

[ QUOTE ]
My Excel knowledge lacks here. How would I perform an IF on the type of value to see if it's a number?

Thanks,
JWP

[/ QUOTE ]

=IF(ISNUMBER(A1),TRUE,FALSE)