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
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
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.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks