I would restructure your table to make it simpler but this works. From: x x Sent: Tuesday, August 16, 2011 7:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Table - extract some data
Folks, please give me a hint about table attached. I'd like to find a way to extract exact and wished value from table but of course regarding pre-existing required conditions. For instance, if someone choose diameter 40, left diameter 10 and delta 60 excel should get in some empty cell the value 40,2. Like crossword game. How to do it? I've tried with filters and some if, vlookup functions but it seems to be to complicated for my excel level of knowledge. Teach me. Many thanks. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
examplei.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
