But do not forget to lock the lookup_range using $ symbols. The spreadsheet name and the range should not cause any trouble.You can find the spreadsheet-id of your Excel Online workbook in the URL bar.The parameters we need for our VLOOKUP formula are: We’ll use the same workbooks from above – dataset and users – but edited in Excel Online. Or you can look up from another spreadsheet using this syntax: =VLOOKUP("lookup_value",'sheet-name'!locked-lookup-range,column_number,match) The simplest way to solve this is to import the required data from another workbook ( Excel to Excel) using Coupler.io and perform the vlookup as above. You can’t select the range to look up from another spreadsheet. Unfortunately, the flow described above for VLOOKUP does not work with Excel Online workbooks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |