| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whether VLOOKUP can find Text
Whether Vlookup will find Text?
In sheet 1 my data is as follows B C D 1 Foreman Day 375 2 Mason Day 250 3 Fitter Day 250 In Sheet 2 My formula is as foolows B C 5 Foreman VLOOKUP(B5,Sheet1!$B$1:$D$50,2) i NEED A RESULT OF dAY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup to find match only part of a text value | Excel Discussion (Misc queries) | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| EXCEL: Truncating Text Fields to allow Vlookup searches to find da | Excel Worksheet Functions | |||
| how do i use VLOOKUP to find text and return a number? | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Threaded Mode
