**Program:** Excel 2010  

**Experience:** Basic 

Issue:  

I am using INDEX/MATCH  

This is the original cell which resolves to:  

1) 1.0692 (exchange rate)  

2) 147.50 (exch \* value)  

3) $39.99 (prod cost)  

4) Ex: 1.0692 SubT: 147.5046936

```
=INDEX(ssExchRate,MATCH(A33,ssRepDist,0))  
=" SubT: " &INDEX(ssExchST4,MATCH(A33,ssRepDist,0))  
=INDEX(ssUnitPr,MATCH(A33,ssRepDist,0))  
="Ex: "&INDEX(ssExchRate,MATCH(A33,ssRepDist,0)) & " SubT: " &INDEX(ssExchST4,MATCH(A33,ssRepDist,0))

```

To be able to get $ or - (for discounts) I need to use: 

```
="-$"&INDEX(ssBankAU,MATCH(A33,ssRepDist,0))  

```

Is there a way for the formula to retain cell information, or do I have to hardcode it like my final example?

Cheers.