Microsoft Office Excel to manage application data

Question

question

MacOssai-6546 asked May 4, '22 CeasarChenMSFT-3458 commented May 10, '22

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

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

MacOssai-6546 · May 04 at 06:33 AM

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 ·

Answer 1 · 2022-05-04T07:52:40.05Z

CeasarChenMSFT-3458 answered May 4, '22 CeasarChenMSFT-3458 commented May 10, '22

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.

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

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

CeasarChenMSFT-3458 · May 10 at 06:04 AM

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

0 ·

question