Bowling spread sheet stats difficulties with formulas.

October 31, 2017 at 06:18:02
Specs: Windows 7
Can someone look at my spread sheet and let me know if it is fixable. Another person sent the copy to me converted from Apple Numbers and now the "lookup" formulas aren't working?
I can provide the sheets if necessary.

See More: Bowling spread sheet stats difficulties with formulas.

Reply ↓  Report •

#1
October 31, 2017 at 06:30:00
What does 'now the "lookup" formulas aren't working' mean? Are you getting formula errors? Are you getting incorrect results?

Would it be possible to post some examples of the formulas (cut and paste) so we can see what they look like? Maybe it's just a syntax issue. A brief explanation on how they are supposed to work might help also.

If you post the workbook to zippyshare.com and then post the link back here, we can take a look at it, but I think I'd like to get a few more details before we go that route.

If you do upload the workbook, make sure that there is it doesn't contain any personal or confidential information.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
October 31, 2017 at 07:25:09
=LOOKUP(A3,Averages!$A$3:$A$28,Averages!$B$3:$B$28)

This would be one of the formulas I am trying to work with.
I was going to save my sheets on a stick and try to change them over to a word/ excel program in windows 10 on my other PC to see if that would help.


Reply ↓  Report •

#3
October 31, 2017 at 07:59:15
I'll try my question again:

What does 'now the "lookup" formulas aren't working' mean? Are you getting formula errors? Are you getting incorrect results?

The syntax appears to be correct but obviously I don't know how your workbook is set up so just because your formula works for me may not mean much.

If I knew what "aren't working" means, I might be able to help more.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question