Solved How to search two values on a row on a different sheet?

October 28, 2016 at 07:32:57
Specs: Windows 64
In Excel, I'm trying to figure out how to write function for - If row in "Report" sheet contains "Cell value", and "Cell value", yes. If not, no.

See More: How to search two values on a row on a different sheet?

Report •

#1
October 28, 2016 at 08:09:21
Need a bit more info,
but I would guess that a VLOOKUP() function should get you what your looking for.

Are you looking for a specific Row, or Cell?

MIKE

http://www.skeptic.com/


Report •

#2
October 28, 2016 at 08:18:18
I have a "Tracking Sheet" which is tracking custodians, their property, and their training classes. My "Training" sheet contains a list of names and two different classes. I want to look on that sheet and return a yes or no, basically searching each row for a specific custodian name and class name (must have both).

Report •

#3
October 28, 2016 at 09:28:37
✔ Best Answer
OK, try this.

With your sheets looking like:

Sheet Name: Tracking

         A                  B               C
1)     Name             Training 1      Training 2
2) Harry Potter            
3) Ron Weasley             
4) Draco Malfoy            
5) Neville Longbottom      

Sheet Name: Training

         A                  B               C
1)     Name             Training 1      Training 2
2) Draco Malfoy            Yes             No
3) Harry Potter            Yes             Yes
4) Neville Longbottom      No              No
5) Ron Weasley             Yes             Yes

On Sheet Tracking, in cell B2 enter the formula:

=VLOOKUP($A2,Training!$A$2:$C$5,2,0)

On Sheet Tracking, in cell C2 enter the formula:

=VLOOKUP($A2,Training!$A$2:$C$5,3,0)

Drag down and your Tracking sheet should now appear as:

         A                  B               C
1)     Name             Training 1      Training 2
2) Harry Potter            Yes             Yes
3) Ron Weasley             Yes             Yes
4) Draco Malfoy            Yes             No
5) Neville Longbottom      No              No

Modify the formula to reflect your actual Columns and Rows.
See how that works for you.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
October 28, 2016 at 10:49:25
Thank you for your help.

Report •

Ask Question