Returning a value to a single cell based on multiple values elsewhere.

Re: Hi: I am Archie.I have a list of 0's and 1's listed in a column (in a table). in another column in the same spreadsheet I have a list of model names. In a separate spread sheet, there is a list of the model names in one column, and a list of numbers in another column. I want to return the number in the last column to a single cell in another sheet when there is a value >0 in the first column of the first sheet (whew!)

Can anyone help?

Thank you.!

Welcome to the Forum, Archie. Sounds like a simple VLOOKUP function will work. Can you post a sample spreadsheet (personal/ business sensitive data removed) so I can work on a solution for you?