SoftMaker.com

Thank you.

I would like to look up the text value typed in a cell and from another text list that is not sorted I'd like the result after it. I've looked at Match and Index but can't seem to make them work. As an example I have a column of unsorted text - Tom, Mary, Bill, Gary in D5 to D8 and in E5 to E8 I hav...

Sorry about the duplicate post. I'd forgotten I'd already asked and someone answered but didn't see the notification until after I clicked Submit. I didn't think too much about second post because when I clicked on Submit nothing seemed to happened so thought something went wrong and just closed my ...

Thank you. Second option worked great.

I have a worksheet that starts with column B and haven't been able to find a way to reveal column A. I've tried a number of steps from he help file but have been unsuccessful. Anyone know how to show a hidden column?

At some point the the past I created a worksheet by copying and pasting data from another worksheet. I have formulas tied to the new worksheet and everything is working fine. When I recently looked at the columns and their data I noticed that Column A is not shown and it starts with Column B. I thou...

Thank you.

I have a file that has 3 tabs. The first tab is an index and I'd like to put a hyperlink to another tab so clicking on a cell will take me to a specific cell in another tab. An example is tab INDEX and the other tabs TAB A and TAB B. Click on a cell in INDEX will take me to TAB B cell A12. I've trie...