Formulas not working in Google sheets that work in Excel - Help?

[KatyMac]

I have a lovely spreadsheet in excel with lots of fab formula (Vlooup and Iferrors etc) & when I import it into Google sheets the formula don't work

Am I being daft or are they not compatable?

Had similar issues myself before with complicated formulas and formatting. I try and avoid GS for anything more than very basic spreadsheet. Sorry not much help.

Is it crap?

My excel is amazing!! (even if I say so myself, I had lots of help with it)

Google suggests this

But I'm not sure that would help

Why do you need to use GS instead of excel?

I'm helping some friends with their recording of data and they use google sheets so hey can each edit it

I've only every used Excel (or something archaic back in the early 90s) so I'm a bit lost

Google Sheets is fantastic but I don't think the two are compatible enough for you to just import and hope for the best; you'd have to rewrite the queries or use a third-party tool.

SO do you know what

=IFERROR(VLOOKUP(A7,Input!A:AH,7,FALSE),0)+(IFERROR(VLOOKUP(A7,Input!A:AH,8,FALSE),0)*-1)

would be in Google Sheets speak?

I do wonder if it's the A:AH?

Have you googled GS formula help

I spend my life googling excel stuff!

Try using semi colons instead of commas in the clause

Oh I have been googling I promise

I built the formula in Sheets but when I copied it down the coloumn it didn't change the first coloumn identifier

Urgh that is so frustrating, how about I send you my conditional formatting problem to solve, it's in excel

No problem message me your email, I'll reply and then send it through

I love a good spreadsheet but I hadn't realised how hidebound I was by Excel

Is there something special about linking to another sheet?

LOL it's a work thing I'll keep plugging away seeing as I'm being paid...

I think there’s somthjng wrong with your range,what error is it returning?That doesn’t look like your copying the range down as constant to me.

Sorry your array I mean.

You normally have to fix your array with $

I'm not getting an error I'm getting an empty field

Is there a recalc button or is it real time?

The field is a seond page with data in

Random - just message me the formula & describe the problem.....I don't mind

So Input!A:AH should be Input!A$:AH$ ?

If you just copy the cell then only the number gets copied, you need to block the formula from the box at the top of the excel sheet, and copy and paste into the cell in Google.

=VLOOKUP(A7,Input!A$:AM$,8,FALSE)

Even this is returning blank

It's hard without the data!

Yes to array with $ but not sure what the *-1 is asking it to do?

Should it be IMPORTRANGE rather than input?

Not used input before what is it meant to do?

Oh I have income and expenses so need a positive or negative number in my answer & my friends don't understand 'numbers' very well and couldn't enter a negative number

Forever bubblegum I have the formula in place it just ins't working how I would expect

Oh! Input is the name of the sheet - does it do something in Sheets should I change it?