Hi,
I know that Conditional formatting doesn't carry over when using a Vlookup.
I am using a Vlookup to search data on a different sheet and return the value from a different column in a different cell.
Product cost is the returned value.
Code is the user entry.
The formula in Product cost uses vlookup to search a different sheet with a list of 3500 items for the text in the Code column. then returns the value in the Product cost column.
Some of the returned values are formatted on the basis that the original search text is duplicated.
I want to high light the returned value if the original text is duplicated.
Any thoughts?
I know that Conditional formatting doesn't carry over when using a Vlookup.
I am using a Vlookup to search data on a different sheet and return the value from a different column in a different cell.
Product cost is the returned value.
Code is the user entry.
The formula in Product cost uses vlookup to search a different sheet with a list of 3500 items for the text in the Code column. then returns the value in the Product cost column.
Some of the returned values are formatted on the basis that the original search text is duplicated.
I want to high light the returned value if the original text is duplicated.
Any thoughts?