close
How do I set up a function that is conditioned by....
if any cell in column A equals a certain number than the C cell in that
particular row will equal a particular name?
John,
Starting with your first value in A then in C,
=IF(A1=Your Value,quot;Your Namequot;,quot;quot;)
Copy this down your range. This will return a name if the condition is
true and a blank cell if not true.
Cheers,
Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=497902
全站熱搜
留言列表
