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,