Help with if and vlookup

[sirnel]

I want to search column A for all rows with the value “non-match” in column A. Then I want to look-up the value in column C of that row and search for it in the table to find a row where the value in column C is the same but the value in column A is “seems valid.” Once that is found I want to return the value in Column D for the “seems valid” row to the “non-match” row.

I have the following problem and am trying to use If and Vlookup functions but can’t seem to figure it out.


any thoughts?

[TMS]

Please post a sample workbook with some typical data and explain what you're starting with and what you want to end up with ... and how and why.

Regards

[sirnel]

so i can't go into too much detail about why/what I'm working on, but here's an example spreadsheet.

1. I want to be able to type the formula into cell D2,
2. have it recognize the value in A2 as a non-match
3. then using the value in C2, find C11
4. verify that A11 says "seems valid"
5. look up D11, and return the value in D11 to D2

i'm not sure that having recognizing A2 as a non-match is necessary since I can sort by non-match and manually input the formula into the D column for each non-match row..

please let me know if that makes sense.. thanks!

[sirnel]

and this is what i want to end up with. imagine there are thousands of values and inconsistent amounts of duplicates of the values in the C column which I have to keep..