Hello,
I hope this request is not too wacky.
This f returns the contents of E20 (which in this case is "1750 - 0410")if
the look up finds a cell that starts with a number but if the look up finds a
cell that starts with a letter then it returns the content of the found cell.
Now I want to add to this, something that states if the lookup finds a cell
that has "Swch" in it then return the contents of that cell along with the
contents of E20

=IF(ISNUMBER(LEFT(VLOOKUP(E27,'[D Patrol Log Even.xls]Patrol
Log'!$C$22:$M$45,11,0))+0),$E$20,IF(ISTEXT(LEFT(VL OOKUP(E27,'[D Patrol Log
Even.xls]Patrol Log'!$C$22:$M$45,11,0))),VLOOKUP(E27,'[D Patrol Log
Even.xls]Patrol Log'!$C$22:$M$45,11,0),""))

Thank You
Brian