example.xlsx (9.4 KB)
What I’m looking to do is based on a value I’ve captured in another program (which is assigned to a variable), I want to use that to search the appropriate sheet and then column in an Excel File.
So using the attached worksheet as an example, I’ve captured ‘Samsung’ and ‘Memory’ to a variable
The Flow would then open up the attached Excel file, it would match ‘Samsung’ with the 1st variable and so it loads up the sheet relating to Samsung.
It then would utilise the second variable ‘Memory’ and so read ‘32GB’ and then I would open a browser and type in 32GB and then get text with what info I need i.e. price
Scratching my head with this one though so any help and advice would be most welcome