Column G also has the same text as column header. How do you decide whether it is column G, or column I??
Sam On Sat, Jul 21, 2012 at 10:51 PM, vijay yadav <vijay.ganesh.ya...@gmail.com>wrote: > Dear Friends/ Excel Experts > > I need formulae to pick next highest value by checking two input values 1) > text and 2)number > > input cells are A53 (TEXT) and A54(NUMBER) > > formuale should OUTPUT NEXT highest value to number in A54 > > TEXT IS COMPARED TO A NUMBER OF TEXT ENTRIES IN ROW 1 > AND NUMBER IS IN CORRESPONDING COLUMN FROM ROW 1 TO 34 > > I have attached the sheet with detailed understanding of problem > Please help > > Example > ROW1) BAT BALL CHAIR CYCLE WATCH PEN MAT > ROW 2 ) ALL NUMBERS > . ALL NUMBERS > . ALL NUMBERS > ROW 34 ALL NUMBERS > > A53 = BAT A54 = NUMBER > > OUTPUT SHOULD BE IN A55 AS A FORMULAE > FORMULAE SHOULD READ NEXT HIGHEST NUMBER TO NUMBER IN A54 BELOW "BAT" AND > OUTPUT IT IN THE CELL A55 > > Regards > Vijay > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Sam Mathai Chacko -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
