Am I doing something wrong? I am using the lookup function to determine some text in a cell. Some of the values come back correctly and others do not. Some times I also get a #N/A result.
What I was hoping for was if the cell (B6) has a particular word in it, then the cell this formula is in would show the abreviated name. I could use a number of nested IF formulas or some VB code but this seems more straight forward.
What I was hoping for was if the cell (B6) has a particular word in it, then the cell this formula is in would show the abreviated name. I could use a number of nested IF formulas or some VB code but this seems more straight forward.