Combining VLookup & IF?

**brianjluke** · 06-13-2013, 10:41 AM

Hi, this novice needs some help, I'll try to explain the best I can.

In sheet 2, cell A3, I need to return an employees name from sheet 1(cell A2) if the value of column Q(17 columns from the left) from the same row is equal to 1

Sheet 1 is an employee list table with different attributes in columns B through S, column A is the employee name

Any help would be greatly appreciated!

**Ace_XL** · 06-13-2013, 10:48 AM

In A3 on Sheet 2

=index(Sheet1!A:A,match(1,Sheet1!Q:Q,0))

**Moo the Dog** · 06-13-2013, 10:49 AM

Why not just use IF:

=IF(Sheet1!Q2=1,Sheet1!A2,"")

Or if you need to search through the data to find the employee with a 1 in column Q, then you could use:

=INDEX(Sheet1!A2:A20,MATCH(1,Sheet1!Q2:Q20,0))

(Adjust range height as needed)

Only problem with that is that it will only return the FIRST employee with a 1, not all of them.

- Moo