For getting the specific value from the table based on some condition, we use setrange and find function, for example we have to find department name whose “Dimention code” is “AREA” and it code value is ‘5000’ .
a. Fist declare Dimention Value table as record.
b. Now write below code
This above code display name of the department whose code is 500