Formulas

[Cheryl88]

Hi,

First time posting so I hope I make sense.
I’m just studying excel and have an assignment to complete and I am stuck on which formula I need.
I need to check if a provider on sheet 1 e7 is on the approved list on sheet 3 a1:02 and to return a yes or no answer

Am I best to recreate sheet 3 so I can do a hlookup, but would I be able to get that to return a yes or no?

Many thanks in advance

 

[Fluff]

Hi & welcome to MrExcel.

Have a look here
https://exceljet.net/formula/value-exists-in-a-range

 

[MB110]

Hi, Welcome to MrExcel,

If you need to return a yes or no then you could use Fluff's suggestion, which returns true or false, and wrap it in a conditional statement.

=IF(COUNTIF(count_range,criteria_range)>0,"Yes","No")

Hope this helps,
MB110