Vba vs formula

[tbpugh866]

I am not certain whether vba is needed or a formula. I first posted under the formula forum but because I have not received any help I thought it may be appropriate for this category. I am under the gun and need help. I am self taught. Here's the problem:

A row in my spreadsheet is comprised of 4 groups of related data. For example, a name, age, weight, height for 4 different people, so columns A through P. I want to look for those people in the row and find the person with a specific age and display their name and weight if their weight is the greatest. For example, there's 2 people that are 20 (the age I'm searching for). One person is 108 and the other is 150. I want the name and weight of the 150 pound person. How do I do this? There could be any number of persons on a single row.

Example

Tom 20 108 5 Sarah 35 190 6 frank 20 150 5

The formula or vba code returns frank 150

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Pepe Le Mokko]

Cross posting between forums is nor advisable nor allowed. VBA gurus will also look at the formula forum, no probs.

http://www.excelforum.com/excel-form...ml#post3461476

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.