Dear Experts In the attached sheet I have the formuale in A55which gives a output by checking the A53 and A54 cells.Also I need outputs in cells A56,A57,A58 and A59. Please help me to get these values. The Answers are in same row ,as the row from where the output in A55 had come under the headers-"HEADER","RPM","GD sq" and of the adjacent row Please see the attached file Please help Regards Vijay
On Sunday, 22 July 2012 02:21:21 UTC+5:30, vijay yadav wrote: > > Great, > > This was exactly what i wanted, > > Please help me to get some more values in same row under the > headers-"HEADER","RPM","GD sq" and of the adjacent row > > All these values are from the same row as the row from where the output > had come > > Please see the attached file > > Thanks for you very very fast and accurate answer in previous reply. > > Please help > > Regards > Vijay Yadav > > On Saturday, 21 July 2012 22:51:37 UTC+5:30, vijay yadav 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
