Putting values into variable from a case by case basis

Putting values into variable from a case by case basis

Okay i have 2 variable named bid price and offer price . I need to fill in
the values into the variables through cases.
For each row of data ,i want to retrieve the rates for the currency pairs
(eg. eur/usd,audusd) . I have 2 values for each currency for bid and offer
price( eg $bid ,$bid1,$bid2,$bid3,$bid4,$bid5,$bid6. For clarification ,
one pair has 2 variables which i want to put the variables in. So if the
row's currency pair is eur/usd , i want to take $bid and $bid1 or if its
usd/jpy, i want to take $bid2 and $bid3. so these go by a case basis which
does it in a for-each/while loop ( row). Any idea how can i do this?