| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whether VLOOKUP can find Text
Thank you very much it worked perfectly :). "Ashish Mathur" wrote: Hi, Just add 0 as the last argument. Please try this VLOOKUP(B5,Sheet1!$B$1:$D$50,2,0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "vmohan1978" wrote in message ... 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Whether VLOOKUP can find Text
You are welcome.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "vmohan1978" wrote in message ... Thank you very much it worked perfectly :). "Ashish Mathur" wrote: Hi, Just add 0 as the last argument. Please try this VLOOKUP(B5,Sheet1!$B$1:$D$50,2,0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "vmohan1978" wrote in message ... 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 |
| Reply |
| 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) | |||
Hybrid Mode
