=IFERROR(VLOOKUP(D2;A1048560:B1048563;2;0);"")
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ALAM Sent: Monday, September 13, 2010 3:24 PM To: excel-macros@googlegroups.com; toexcel-mac...@googlegroups.com Cc: noorain.ans...@gmail.com Subject: $$Excel-Macros$$ APPLICATION SHEET Dear All, I want to make Application sheets but we facing different query. I want to……………………….. 1. Serial no should be auto number 2. Relation from validation. 3. Sex column should be change according to relation column 4. Category should be validation 5. Age remark should be changed by selection of DOB ( DOB1 DOB2 Age Remark1 Age Remark2 Age Remark3 01/01/1973 01/01/1992 Above Age Under Age OK 01/01/1968 01/01/1992 Above Age Under Age OK 01/01/1968 01/01/1992 Above Age Under Age OK 01/01/1970 01/01/1992 Above Age Under Age OK 01/01/1965 01/01/1992 Above Age Under Age OK 6 Qualification column should be change according to Max Code column 7 Division column should be change according to Sub_Div column 8 Remark Details column should be change according to Remark column Note:-------------- "#REF! " should note present in cell due to VLOOKUP command. -- Regards&Thanks, AFTAB ALI 9310903589 -- ---------------------------------------------------------------------------- ------ 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe