• 468K Members
• 10.6K Online
• 565K Conversations

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.

Highlighted

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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies