Thread: Can we use multiple if with VLookup function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Multiple IF's with Vlookup Multiple IF's with Vlookup is offline
external usenet poster
  
Posts: 1
Default 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,

Reply With QuoteReply With Quote