Forum Discussion
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 populated with Company names.
- I want the cells in column C to be populated with the word 'Gateway' when one of the Company Names in Column U is used.
Regards,
John Cassidy
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
4 Replies
You may try this...
In C2
=IF(E2="","",IF(ISNA(MATCH(E2,U:U,0)),"","Gateway"))and copy it down.
As per the formula, if a cell in column E is empty, the formula will return a null string i.e. blank otherwise the formula will use MATCH function to look for the company name entered in column E and check whether it is present in column U or not and if a company match was not found the Match function will return #N/A error to the outer function ISNA which will then be evaluated as true and the formula cell will return a blank again else if a company match is found in column U, the formula will return Gateway in column C.
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
- Thank you tauqeeracma
You're Welcomejohnjamescassidy
