Searchmetrics rankings by keywords in column

This seems like a simple enough operation that I hope there's a simple solution. So if there's an existing topic elsewhere on the board, please be kind - I didn't find it.

I have a column of keywords to check in Excel already. I have a Searchmetrics paid account, tracking these specific keywords.

What formula would I use to check the keyword in cell A2 (for example) and find out how we rank for it according to our last Searchmetrics crawl?

Thanks!

Hi,

I don't think request is available in the SeoTools Connector. However, it is possible to implement. Can you look at the following API page and see which API call is the one you are referring to?
http://api.searchmetrics.com/api-calls

It might be one of the alternatives under the "Projects" category:

You can hover with the mouse over the alternatives and see a description.

Best regards,
Victor