Hi everyone,
I am using the following code to pull details into a specific cell
=IF(ISNA(VLOOKUP(S7,customer,2,FALSE)),"",VLOOKUP(S7,customer,2,FALSE))
Is there a way i can have the cell formatting copied as well as the text' i.e if certain words are highlighted in red it represents this in the field containing the code?
Bookmarks