Searching a column for a specified date then returning the values in the row

[dtaganovic16]

Hi ive been having a little bit of trouble with this. Basically i want to search a column for a value in a if statement is that possible to do? THen once the value is found in that column i want to take to cells of data from the row were the date was found and copy it into the cell with the formula. If you know how to make it work for finding the data and returning it in the cell im more that 99% sure that i can get it to give me the cell data for that row.

[K m]

Do yo have a test worksheet?

MATCH Function will tell you what row the match was found. That should give you a start

[dtaganovic16]

yeah i tried the match function wasnt to familiar with how it works i used it and it kept returning the wrong date