Thread: If column A contains text, vlookup column H on the same row
View Single Post
 
Old 11-06-2015, 07:38 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
Perhaps:

=IFERROR(Vlookup(INDEX(A5:A39,MATCH("*",F5:F39,0)) , operator,2,False),"")
Reply With Quote