B
BLUV
I have 2 worksheets. This first worksheet I am using a formula to strip out
6 numerics from a cell of mixed alpha numeric characters. Here is the
formula I am using successfully.
IF(ISERROR(MID($B2,FIND(" -",$B2)-6,6)),"0",MID($B2,FIND(" -",$B2)-6,6))
Worksheet 1
A B C
2 807600 A807600 - Apps Platform Facility 272.2
Now, on the second sheet I would like to perform a vlookup function similar
to the one below. Where 'TimeTotal's is a reference to cells = 'Worksheet
1'!A2-C400
VLOOKUP(807600,TimeTotal,3,FALSE)
The current way I have this returns '#NA' in the VLOOKUP, but I can see
807600 listed on the other sheet. Can you help me get this to work?
6 numerics from a cell of mixed alpha numeric characters. Here is the
formula I am using successfully.
IF(ISERROR(MID($B2,FIND(" -",$B2)-6,6)),"0",MID($B2,FIND(" -",$B2)-6,6))
Worksheet 1
A B C
2 807600 A807600 - Apps Platform Facility 272.2
Now, on the second sheet I would like to perform a vlookup function similar
to the one below. Where 'TimeTotal's is a reference to cells = 'Worksheet
1'!A2-C400
VLOOKUP(807600,TimeTotal,3,FALSE)
The current way I have this returns '#NA' in the VLOOKUP, but I can see
807600 listed on the other sheet. Can you help me get this to work?