IF Statement for Range of options

[BrianP1]

Trying to find if this is possible. I have a list of names which I am trying to do If Statements on. I need the if statement to return a value if a specific cell equals one of the names on the list. The list contains 75 people so would need multiple if statements. Instead of doing an if statement for each name on the list, is there a way for the if statement to look at the entire list at once (using a range or something)?

 

[BrianP1]

OK, back to the VLOOKUP:

	A	B	C	D	E	F	G	H	I	J
Company	Deal	Rep	Amount	Product	Acct. Exec	Rep	Acct. Exec
Company x	Deal 1234	Joe Smith	Product X	Samuel Rogers	Richard Watson	Thomas Preston
Company D	Deal 3364	Bob Hope	Product P	Thomas Preston	Bob Hope	Thomas Preston
Company Q	Deal 2575	Rick Burns	Product A	No	Jane Doe	Thomas Preston
Joe Smith	Samuel Rogers
Eric Poster	Samuel Rogers
Trish Nixon	Walter Lin
Erica Andrews	Walter Lin

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]$142[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]$443[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]$236[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]F2[/TH]
[TD="align: left"]=IFERROR(VLOOKUP(C2,$H$2:$I$8,2,0),"No")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks Eric! That worked perfectly. I was able to use it as a nested set of code as shown here: =IFERROR(VLOOKUP($AG5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($M5,VST!B$14:C$85,2,0),IFERROR(VLOOKUP($N5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($AC5,VST!B$11:C$85,2,0)," No"))))

Do you happen to know how to do this in Microsoft Access or know of a forum that would help like this one? Thanks again!

Brian

 

[Eric W]

Glad you got it working! I'm a little curious why your second VLOOKUP has B$14 instead of B$11, but I guess you have a reason.

As for Access, my skills are way out of date. But there is an Access forum here, just post your question there.

 

[BrianP1]

Thanks Eric. As for why I started on 14 for the 2nd set, the 1st three reps listed wouldn't be in the column it was searching in. Could have left it the same as the others.