Sign in to follow this  
Followers 0
socceraddict

Excel VLOOKUP function

2 posts in this topic

#1 ·  Posted (edited)

Hello. I've got a variable from my autoit script (let's call it $age). Is it possible to use $age and Excel's VLOOKUP funtion to find a 2nd value in an Excel spreadsheet, and then save that 2nd value as another variable ($rate)?

Thanks for the help.

Edited by socceraddict

Share this post


Link to post
Share on other sites



You could definitely do that. Since it's just an Excel formula function, assign the formula to the cell, calculate, then read it's value.

If you're unsure how to do these things with AutoIt, hit the link in my signature for my collection of functions, or look up Randallc's ExcelCOM function collection.

In my collection, there is a function that will do a search which will return all cells in the range that contain the search phrase.

-S


(Yet Another) ExcelCOM UDF"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly...[indent]...specialization is for insects." - R. A. Heinlein[/indent]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0