• 460K Members
• 10.5K Online
• 557K Conversations

Highlighted
New Contributor

# If a person's name is found in a named range then execute formula

Hi, first post here, looking for some help....

Please see screenshot, could someone help me with the formula so values in F12, F13 and F14 display values that I'm after shown in C12, C13 and C14.

The formula I started off for E12, E13 and E14 is pasted below, but as the staff number grow it'd be very time consuming to update.

=IF(OR(A12="John 1",A12= "John 2"), B12/\$A\$8, IF(A12="John 4",B12/\$B\$8," "))

I'm trying to use Named Range to create FullTime and PartTime so in the future only need to update the range cells instead of having to update multiple cells, but I failed somewhere....

=IF(found(A12,FullTime), C12/\$A\$8, IF(found(A12,PartTime),C12/\$B\$8," "))

Many thanks.

2 Replies

# Re: If a person's name is found in a named range then execute formula

That could be

`=B12/\$A\$8*(COUNTIF(FullTime,A12)>0)+B12/\$B\$8*(COUNTIF(PartTime,A12)>0)`

Even better use not named ranges but Excel tables.

# Re: If a person's name is found in a named range then execute formula

Thanks @Sergei Baklan that works, much appreciated.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies