question

MacOssai-6546 avatar image
0 Votes"
MacOssai-6546 asked CeasarChenMSFT-3458 commented

Microsoft Office Excel to manage application data

I am trying to move all our processes from Google sheet to Microsoft Office Excel and i was wondering if Microsoft office excel can be used just like Google sheet?

Ideally, It should be easy to create/edit/update the sheet and can connect to APIS. Any advise will be appreciated.

Thanks

office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

To provide an example . We have a dog calculator that retrieves data from sheets via Jquery and based on user input or selection of the dog breed and size, a query is done to the sheet to retrieve a specific column. Is this possible?

0 Votes 0 ·

1 Answer

CeasarChenMSFT-3458 avatar image
0 Votes"
CeasarChenMSFT-3458 answered CeasarChenMSFT-3458 commented

Hi, @MacOssai-6546
Are you trying to search for specific values based on specific criteria?
You can try to use filter function or VLOOKUP function.
Select the column to be filtered, click the Data tab, and click Filter.
198782-image.png
To use the VLOOKUP function, you can refer to this link: https://support.microsoft.com/en-us/office/look-up-values-with-vlookup-index-or-match-68297403-7c3c-4150-9e3c-4d348188976b


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.







image.png (12.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @MacOssai-6546
Did you try my method, is the problem solved?

0 Votes 0 ·