| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
get currency format from souce cell(s) of a formula or referance
I used a index formula as "=INDEX('PRICE LIST'!$A$1:$D$71; MATCH(A7;'PRICE
LIST'!$A$1:$A$71;); MATCH($A$1;'PRICE LIST'!$A$1:$D$1;))" which returns a specific value in the intersection of targetted column and row reference. But I need to get also the number format as currency of the returning cell since it's varies according to intersection. Custom formating nor conditional format did not help at all. So could you pls help me on this issue. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Currency in-cell | Excel Worksheet Functions | |||
| Formula for Detecting Currency Format | Excel Worksheet Functions | |||
| Can I change currency format using a switch/formula | Excel Discussion (Misc queries) | |||
| Formula that referance a Cell | Excel Discussion (Misc queries) | |||
| Cell referance for formula | Excel Worksheet Functions | |||
Threaded Mode
