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)?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
IF Statement for Range of options
- Thread starter BrianP1
- Start date
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
Upvote
0
Excel Facts
How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 13,335
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.
As for Access, my skills are way out of date. But there is an Access forum here, just post your question there.
Upvote
0
Similar threads
- Question
- Question
