# Excel Gurus

**URL:** <https://forums.speedlife.net/t/excel-gurus/22373>\
**Category:** NYSpeed Off Topic\
**Created:** [December 31, 2006, 12:07pm UTC](https://forums.speedlife.net/t/excel-gurus/22373 "2006-12-31T12:07:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\
**Post date:** [December 31, 2006, 12:07pm UTC](https://forums.speedlife.net/t/excel-gurus/22373/1 "2006-12-31T12:07:52Z")

</div>

making an if statement that i can copy over and over again its gonna basically check the name in row ? colum ? (ie A34 or b43) then if equal to the name spelled out it will out put a number on a different sheet in the same excel file, if the logical test fails then it will check for another name…

this what i have now =IF(FN92=OR(name1,name2),Sheet3!N24,0)

name1 and name 2 are the same name, just may look different … (like if someone was saying (Buffalo or at Buffalo)

the name also has spaces, basically i’m trying to nest an OR statement into an IF statement that checks for a Specific name, then i can output this code copy and paste this code 1231212 times and debug the names if i have to … with the properspellings, i really don’t want to replace every space with a \_ or have no spaces in the name

---

<div class="post-metadata">

**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\
**Post date:** [December 31, 2006, 12:13pm UTC](https://forums.speedlife.net/t/excel-gurus/22373/2 "2006-12-31T12:13:47Z")

</div>

Update: I was able to do the

=IF(A36=“Jim\_Bob”,1,0) it passed and gave me a 1  
=IF(A36=“Jim Bob”,1,0) Also worked, its something in the OR statement thats not nesting properly or some error in my syntax

additionally… does anyone know if i can use Regex in excell?

---

<div class="post-metadata">

**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\
**Post date:** [December 31, 2006, 12:28pm UTC](https://forums.speedlife.net/t/excel-gurus/22373/3 "2006-12-31T12:28:14Z")

</div>

Figured it out…

Or statements nested into IF statemtns you have to

=IF(OR(“Jim Bob”=A36,“Jon Jim Bob”=A36),1,0)

i was using the 1 for good job it passed, and the 0 for no it fucked up