Missing functions in excel

Occasional Visitor

Currently trying to use the =importrange function but when I type it, it doesn't appear, instead it !name appears.

3 Replies

@RickyKeegs =IMPORTRANGE does not exist in Excel. 

hi i have a similar problem.

I cant use functions like =RAND()

i dont know how.

ty foer help

 

@Riny_van_Eekelen 

@RickyKeegs 

This is probably about Googlesheets

How to vlookup matching value from another google sheet?

 

Additional Information:

VLOOKUP function