• 410K Members
• 9,777 Online
• 466K Conversations
SOLVED

Problem with a IF or Lookup function!

Occasional Contributor

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

4 Replies
Solution

Re: Problem with a IF or Lookup function!

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

Re: Problem with a IF or Lookup function!

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.

Re: Problem with a IF or Lookup function!

Thank you @tauqeeracma

Re: Problem with a IF or Lookup function!

You're Welcome@johnjamescassidy

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies