# 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?

#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?MIKEhttp://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
 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.MIKEhttp://www.skeptic.com/