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?
Re: Returning a value to a single cell based on multiple values elsewhere.
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?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1