Help with crystal reports formula

Can anyone help me with this formula?

declare a variable stringVar catLoc

catLoc is from CAT.LOCATION

IF (USER.LOCATION = A) then catLoc = A1

IF (USER.LOCATION = B) then catLoc = B1 and so on

Then i want to return a value CAT.FIELD1 from the Table CAT depending on the catLoc