Concatenate formatting tips

I am making a spreadsheet and would like the "placement" tab to look at the "years in position" column and go to another tab and find the corresponding data then put that information into the cell that the formula is in. I have concatenated and the value carries out to about 6 decimal and I cant change the formating. I would like it to display as a currency with 2 decimal places.

If you look at the placement tab cell H7 you can see what I am trying to do.

If you change the value in d7 to a value that is on tab 06-09 step plan (b9-b23) then the value is put in other wise noting is returned.

Please let me know if this is the best way to do this, and if not how should I go about it. Otherwise any formatting tips would be appreciated.

Thanks

You can replace your formula with:

=IF(ISNUMBER(MATCH(D7,'06-09 Step Plan'!$B$9:$B$24,0)),INDEX('06-09 Step Plan'!$F$9:$F$24,D7),"")

then format the cell as Number with 2 decimals and check the use 1000's separator or format as Currency with 2 decimals..