Matching names then delivering value in another cell

[dans123]

Hi,

I'm working on a project that has 2 sheets. the 2nd sheet has the raw data and the first sheet will be the sorted data.

To deliver the raw data on sheet 2 to sheet 1, I need the different names on sheet 1 to match to its corrosponding name on sheet 2 then deliver the value in another cell. I don't need the zero values but on some occosions the zeros and numerical values will be switched so i will need a formula that will deliver the numerical value to sheet 1 after it checks which cell contains the numerical value between columns B and C. there will always be a zero and a numerical value in either column B or C for each.

If this needs further clarifying please ask!

I have attached a sample workbook.
Sample.xlsx

Thanks!

[Dunc3142]

I think what you are after is vlookup. see attached