| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and MID Function
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? -- RyGuy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Threaded Mode
