How to search google sheet column and return results from another column, but same row?

Hi! New to VoiceFlow so I apologies for my simple question:

How can I design a flow that requests a variable (order number), searches a google sheet and returns a status for that order number (ex. shipped).

I have been trying to find some tutorials, but it seems like none of them take a variable and returns another variable that is tied to the first.

I have a google sheet that in column one is “order number” and in column two is “status”, but am unsure of what to do in voiceflow. Any step by step tutorials?