8/12/2019 Rumus Excel Vlookup Kombinasi
I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a vlookup:
![]()
I get a general error. Does importrange support this kind of function?
Feb 23, 2018 Bagaimanakah rumus excel Vlookup sebagian kata atau rumus Vlookup sebagian isi dari sebuah sel excel? Bagi setiap pengguna excel, khususnya yang aktif membaca tutorial excel di blog Kelas Excel ini tentunya sudah tahu bahwa fungsi Vlookup pada excel digunakan untuk mencari nilai teks atau angka pada sebuah tabel vertikal kemudian menampilkan data yang sebaris dari hasil pencarian.
-- EDIT --In order to give more details, what I need to do is to extract data from the ceil of another sheet that has the value 201608 on its left. Since importange wants a ceil pointer such as $A$12, I thought to do theese steps:
Hope in this way is more clear.
Luca
LucaLuca
2 Answers
I found the right way. May be it could be useful for someone else.
or
LucaLuca
Just the ID worked for me as well instead of the URL. I had my numbers as text, so kept getting an error at first. Silly mistake, but what you are looking up probably has to be the same kind of thing (text vs numbers).
user10209379user10209379
Not the answer you're looking for? Browse other questions tagged google-sheetsgs-vlookup or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |