Working Man
New Member
- Joined
- Dec 23, 2015
- Messages
- 5
- Office Version
- 2007
- Platform
- Mobile
Hello Wizards! In advance thank you so much for any help. I am self taught and have gotten along "ok" (I spend hours to complete what you all would deem simple) but my current need is too complex for me to think thru. Here goes:
I am attempting to create a lookup from a cover sheet to another sheet in the same workbook. In the lookup sheet there is a list of names (col A) with a table to its right. Columns "J" thru "N" has values related to the name at left of each row. I need to identify which names return a value greater than "0" from column "J", which names return a value greater than "10" from column "K", which names return a value greater than "25" from column "L", which names return a value greater than "100" from column "M" & which names return a value greater than "1000" from column "N".
So to properly express the sheet to be "looked" at: column A has a list of names and each one coincides with a tab in the workbook. The lookup worksheet columns J,K,L,M, & N each lookup data from those tabs and place the data in the J,K,L,M,N cell to the right of each given name. I am trying to have the workbook return the names that meet most of the criteria listed above. So I am not looking to return just one name... unless that happens to be the answer to the criteria list. I am hoping several names will be returned in list form from this lookup.
Unfortunately, I am not as fluent in excel as I wish to be. I hope I explained this well enough. It seems to me as if it is a "lookup IF, AND, AND, AND" kind of a statement. Thanks to you all for entertaining this challenge.
I am attempting to create a lookup from a cover sheet to another sheet in the same workbook. In the lookup sheet there is a list of names (col A) with a table to its right. Columns "J" thru "N" has values related to the name at left of each row. I need to identify which names return a value greater than "0" from column "J", which names return a value greater than "10" from column "K", which names return a value greater than "25" from column "L", which names return a value greater than "100" from column "M" & which names return a value greater than "1000" from column "N".
So to properly express the sheet to be "looked" at: column A has a list of names and each one coincides with a tab in the workbook. The lookup worksheet columns J,K,L,M, & N each lookup data from those tabs and place the data in the J,K,L,M,N cell to the right of each given name. I am trying to have the workbook return the names that meet most of the criteria listed above. So I am not looking to return just one name... unless that happens to be the answer to the criteria list. I am hoping several names will be returned in list form from this lookup.
Unfortunately, I am not as fluent in excel as I wish to be. I hope I explained this well enough. It seems to me as if it is a "lookup IF, AND, AND, AND" kind of a statement. Thanks to you all for entertaining this challenge.