Hi,
In the second sheet i have a table as follows:
CURRENCY / PURCHASE/ SALE
USD ---- 384 ----- 386
GBP ------ 685------- 700
EUR----------- 480-------490
INR-----------8 ----------9
THB----------9 ----------10
AED-------104-----------105
SAR-------102-----------103

In the first sheet I have 6 colomns, In the third("C") colomn i have 2 options either PURCHASE(P) or SALE (S) , and the next colomn (D) user will put currency name like USD or GBP. Now i wanted to fill automatically the respected rates in the colomn(E)
ie. If C colomn is P(purchase) and D colomn is USD and i have to get E colomn as 384. Any solution?
thanks and regards
by
NOWFAL