#1
|
|||
|
|||
Excel Question for Session Tracking
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 |
#2
|
|||
|
|||
Re: Excel Question for Session Tracking
post the formula you are using now for a start
|
#3
|
|||
|
|||
Re: Excel Question for Session Tracking
How about an IF statement that checks if the Lookup returns a number, if so, return that number, else return 0.
|
#4
|
|||
|
|||
Re: Excel Question for Session Tracking
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 |
#5
|
|||
|
|||
Re: Excel Question for Session Tracking
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 |
#6
|
|||
|
|||
Re: Excel Question for Session Tracking
[ 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) |
|
|