Copy row data IF statement

[HoldemHank]

I have a sheet with 3 columns of data. I need a function or script that looks in column A and column B for data. If both columns match the data I am looking for that I want the cell in column C (in the same row it found the match) copied over another sheet.

Hope this makes sense

 

[Paradigm_Shift]

i don't completely understand your post to give you a more exact answer, but you will need to either use the =VLOOKUP or the =MATCH formulas. Excel help has really good tutorials for how they work if you just hit F1 while Excel is active.

 

[HoldemHank]

Driver Laps Time
Hank 1 22.10
Hank 2 22.15
Hank 3 22.2

If column A is the driver name, B the number laps run and Column C the lap time.

I need a function that will look in Column A for a driver name and in column B for number of laps ran and return me the lap time in column C and so one.

 

[Paradigm_Shift]

I'm still not quite sure how you plan to actually compare values. I understand that you want to look for a match in columns A and B, but where is the value you are using to compare?

Try taking a look at a recent thread I posted in: http://www.mrexcel.com/forum/showthread.php?t=577314

It's a similar thing to what you are wanting...but would be much easier in VBA....

 

[HoldemHank]

IF column A says "hank" and column B says "2" return me the lap time in Column C. In this example it would return "22.15"

 

[Paradigm_Shift]

Yes, I understand that part. The question is where you are planing to insert the formula and where your reference cells are...since I am not sure what you want, I'm going to make an assumption. (Please be more specific next time)

The following formula is for the name you want being in A1 on Sheet2 and the lap # you want being in B1 also on Sheet2. I also assume just 3 rows of data in rows 2-4 w/ headers in row 1, like you posted previously, w/ this data located on Sheet1. (NOTE: if you have more than 3 rows of data, you will have to adjust the array references in the following formula.) Finally, type this formula into C1 on Sheet2, BUT DO NOT HIT ENTER!!!

=INDEX(Sheet1!$C$2:$C$4,MATCH(1,(A1=Sheet1!$A$2:$A$4)*(B1=Sheet1!$B$2:$B$4),0))

NOW, hold ctrl + shift, and hit enter. This will add {} around the formula (NOTE: you cannot type these into the formula bar; you will not get the same result.) The {} make it an array formula. And there you have it! If you followed everything exactly, should work.