LOOKUP to include formatting with its Return Value? Formatting Code Function? non-VBA request

Brass Contributor

Without VBA, is it possible for LOOKUP to return formatting of its Return Value?

It is much easier if Formatting Code Function (similar to CODE function) can be exposed to end user.

 

I need to differentiate LOOKUP output from other formulae outputs within long formulae.

21 Replies

@sunnyschindler Use a hard coded target folder of your choice instead of ThisWorkbook.Path

'    path = ThisWorkbook.path & "\" & tmpFile        'get path to a temp file in same folder
    path = "C:\Users\wongsunn\OneDrive - Schindler\Documents\scrap" & "\" & tmpFile        'get path to a temp file