I’ve made a basic sports league tracker in Excel. Now I want to share it online, so I’m trying to move it to Google Sheets. But I’m running into problems. The formulas that worked fine in Excel are giving me errors in Google Sheets.
Here’s an example of a formula that’s not working:
=IF(D4=0,"",VLOOKUP(MIN(Stats!$B$2:$B$11),Stats!$B$2:$O$11,4,FALSE))
This is my first time using Google Sheets, and I’m not sure how to fix these errors. Any ideas on what might be causing this and how to make my Excel formulas work in Google Sheets? I really want to get this working so I can share my league stats with everyone.
I’ve encountered similar issues when migrating from Excel to Google Sheets. The formula syntax is generally similar, but there are some key differences that can cause parse errors. In your case, the VLOOKUP function might be the culprit. Google Sheets can be more sensitive about range references and sometimes requires explicit sheet names.
Try modifying your formula like this:
=IF(D4=0,“”,VLOOKUP(MIN(Stats!B2:B11),Stats!B2:O11,4,FALSE))
If that doesn’t work, you might need to adjust the range references or use IMPORTRANGE if your data is in a separate sheet. Also, double-check that your named ranges transferred correctly. Sometimes recreating them in Google Sheets solves unexpected issues.
If you’re still stuck, sharing a view-only link to your sheet could help pinpoint the exact problem.
I’ve experienced the hassle of converting Excel formulas to Google Sheets firsthand. One aspect to watch out for is how Google Sheets handles functions like ARRAYFORMULA. For instance, try wrapping your formula in ARRAYFORMULA so it automatically applies to a range:
=ARRAYFORMULA(IF(D4:D=0,“”,VLOOKUP(MIN(Stats!B2:B11),Stats!B2:O11,4,FALSE)))
This approach can be particularly useful if you’re planning to drag the formula over multiple rows, as Sheets manages the expansion for you. Also, double-check that your sheet names match exactly as any slight difference might cause a parse error. Breaking down the formula into smaller parts can sometimes help isolate the issue if problems persist.
hey man, ive been there. google sheets can be a pain sometimes. have u tried using the QUERY function instead? it’s pretty powerful in sheets and might work better for what ur trying to do. something like:
=QUERY(Stats!B2:O11, "SELECT D WHERE B = " & MIN(Stats!B2:B11))
give it a shot and see if that helps!