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
1	Company	Deal	Rep	Amount	Product	Acct. Exec		Rep	Acct. Exec
2	Company x	Deal 1234	Joe Smith	$142	Product X	Samuel Rogers		Richard Watson	Thomas Preston
3	Company D	Deal 3364	Bob Hope	$443	Product P	Thomas Preston		Bob Hope	Thomas Preston
4	Company Q	Deal 2575	Rick Burns	$236	Product A	No		Jane Doe	Thomas Preston
5								Joe Smith	Samuel Rogers
6								Eric Poster	Samuel Rogers
7								Trish Nixon	Walter Lin
8								Erica Andrews	Walter Lin
9

<tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula F2 =IFERROR(VLOOKUP(C2,$H$2:$I$8,2,0),"No") <tbody> </tbody>

<tbody>
</tbody>

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.