AUTOMATICALLY CHOOSE COLUMN H OR G DEPENDANT ON CONTENT IN COLUMN.
 

I would like to set my worksheet to display either column H or column G
depending on the content in column A such as if column an content is monday
would automatically display column G if column A in sunday would
automatically display column H is this possible?

AUTOMATICALLY CHOOSE COLUMN H OR G DEPENDANT ON CONTENT IN COLUMN.
 

I would assume that you would have Monday, Sunday, etc as the column header.
Then use match on row 1 to find the column and go from there.

--
Don Guillett
SalesAid Software

"Tigers" wrote in message
...
I would like to set my worksheet to display either column H or column G
depending on the content in column A such as if column an content is
monday
would automatically display column G if column A in sunday would
automatically display column H is this possible?