| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can we use multiple if with VLookup function
Need some help.
I have to extract multiple words from the string using VLookup function. (Example :"Cell A1 "This is the best example") Example : Finding "This" from cell A1- result VLookup (Sheet1) A1:D12 Finding "IS" from cell A1- result VLookup (Sheet2) A1:D20 Finding "BEST" from cell A1- result "Excellect" Need to haev function for this Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can we use multiple if with VLookup function
your post doesnt make sense to me but this formula is my interpretation of
your criteria. -- paul remove nospam for email addy! "Multiple IF's with Vlookup" wrote: Need some help. I have to extract multiple words from the string using VLookup function. (Example :"Cell A1 "This is the best example") Example : Finding "This" from cell A1- result VLookup (Sheet1) A1:D12 Finding "IS" from cell A1- result VLookup (Sheet2) A1:D20 Finding "BEST" from cell A1- result "Excellect" Need to haev function for this Thanks, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can we use multiple if with VLookup function
Thanks!!!
Yes, it is bit confusing. Actually I want to use Vlookup function with IF statement. Please let me know in case i need to send some more information. Thanks again. "paul" wrote: your post doesnt make sense to me but this formula is my interpretation of your criteria. -- paul remove nospam for email addy! "Multiple IF's with Vlookup" wrote: Need some help. I have to extract multiple words from the string using VLookup function. (Example :"Cell A1 "This is the best example") Example : Finding "This" from cell A1- result VLookup (Sheet1) A1:D12 Finding "IS" from cell A1- result VLookup (Sheet2) A1:D20 Finding "BEST" from cell A1- result "Excellect" Need to haev function for this Thanks, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can we use multiple if with VLookup function
I also don't understand what it is that you want to do. However, you
might be able to make use of something like this: =IF(condition_1,vlookup_1,IF(condition_2,vlookup_2 ,"neither of these")) Hope you can make sense of that. <g Pete Multiple IF''s with Vlookup wrote: Thanks!!! Yes, it is bit confusing. Actually I want to use Vlookup function with IF statement. Please let me know in case i need to send some more information. Thanks again. "paul" wrote: your post doesnt make sense to me but this formula is my interpretation of your criteria. -- paul remove nospam for email addy! "Multiple IF's with Vlookup" wrote: Need some help. I have to extract multiple words from the string using VLookup function. (Example :"Cell A1 "This is the best example") Example : Finding "This" from cell A1- result VLookup (Sheet1) A1:D12 Finding "IS" from cell A1- result VLookup (Sheet2) A1:D20 Finding "BEST" from cell A1- result "Excellect" Need to haev function for this Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine multiple values in a table into one cell using vlookup? | Excel Worksheet Functions | |||
| Pastable function using VLOOKUP? | Excel Worksheet Functions | |||
| Index function using multiple values in one cell | Excel Worksheet Functions | |||
| VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
| Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Hybrid Mode
