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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whether VLOOKUP can find Text
yes of course,
VLOOKUP(B5,Sheet1!$B$1:$D$50,2,false) On Jan 30, 12:26*pm, vmohan1978 wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whether VLOOKUP can find Text
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whether VLOOKUP can find Text
Try it like this:
=VLOOKUP(B5,Sheet1!$B$1:$D$50,2,0) The 0 means exact match. When you leave out that last argument the formula assumes your data is sorted in ascending order and if an exact match doesn't exist you want an "approximate" match. However, if the data isn't sorted then you can get incorrect results. -- Biff Microsoft Excel MVP "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 |
#5
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whether VLOOKUP can find Text
Thank you very much it worked perfectly :).
"muddan madhu" wrote: yes of course, VLOOKUP(B5,Sheet1!$B$1:$D$50,2,false) On Jan 30, 12:26 pm, vmohan1978 wrote: 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 |
#7
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) |