Excel Gurus

NYSpeed Automotive NYSpeed Off Topic
1

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

2

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?

3

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