You can either use an Excel Sheet (I prefer this) or QTP's DataTable and store the value in a variable, and compare/match that value in column B and retrieve its corresponding value from column A and use that instead. This only requires a simple Loop.
Something in the lines of this:
So, all you have to do is match the value that you retrieve from the form, compare it with the value in Column B, and retrieve the value from its corresponding row in Column A.
Something in the lines of this:
Code:
Column A Column B
Alabama AL
Alaska AK
... ...
... ...
Wyoming WYSo, all you have to do is match the value that you retrieve from the form, compare it with the value in Column B, and retrieve the value from its corresponding row in Column A.
