Keep number format from original worksheet while using =IFERROR(INDIRECT(

[jmh91986]

Basically, I am using the following formula: =IFERROR(INDIRECT(Config!$C$273&"!"&K$6&$B8),"")
and I am trying to keep the number format from the sheet it is pulling data from. Any ideas?

Thanks

[Richard Buttrey]

Hi,

There's no standard XL function to lookup a format in the way you can with a cell value. You'd need a macro to do it.