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,