Forum Discussion

johnjamescassidy's avatar
johnjamescassidy
Copper Contributor
Sep 14, 2019
Solved

Problem with a IF or Lookup function!

Hi, I am looking for a cell to be populated with the word Gateway if another cell has text from a column present. Is this possible.   i.e. - Column U has 20 Company names. - Column E will be po...
excel
Formulas and Functions
  • tauqeeracma's avatar
    tauqeeracma
    Sep 14, 2019

    Hi johnjamescassidy 

     

    You can use below formula in column C

     

    =IFERROR(IF(MATCH(E2,$U$2:$U$21,0)>0,"Gateway",""),"")

     

    A sample file is also attached for your reference..

    Thanks

    Tauqeer

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Sep 14, 2019

Hi johnjamescassidy 

 

You can use below formula in column C

 

=IFERROR(IF(MATCH(E2,$U$2:$U$21,0)>0,"Gateway",""),"")

 

A sample file is also attached for your reference..

Thanks

Tauqeer

Resources