[Solved]Compare variable against Excel Sheet

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
unimatrix
Newbie
Posts: 3
Joined: Tue Jul 05, 2016 2:48 pm

[Solved]Compare variable against Excel Sheet

Post by unimatrix » Sat Dec 01, 2018 1:07 am

Hello,
i want to compare a variable value with Column A (Excel Worksheet).

Code: Select all

GetTextReset
Let>number1={""}
While>number1={""}
  GetTextInRect>820,498,859,519,number1
  Wait>0.02
EndWhile
Trim>number1,number1
For Example the variable "number1" contains: 33, then it should check with Column A and if there is a match, store the adjacent value (in this case Column B "17,20") in another variable ( number2).

Code: Select all

10 |20,00
22 |13,50
33 |17,20
44 |55,20
55 |48,50
Any suggestions how to solve this problem?

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts