• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS excel question.

D

de8212

Diamond Member
I tried this in Software and didn't get anywhere. I need to get it working as soon as possible.


I have two columns (A and B) and 6 rows (1-6). Now in cell A7 I want to find the maximum # in column A. Let's just say that the maximum # is in A3. That formula is easy. But now if I want cell A8 to display whatever the # is that resides in column B at the Maximum of Column A. So, in my example I want A8 to display the number in B3.
How can I write that formula in cell A8? I tried to write out my example below but I'm not sure how it will show up.
Thanks.
de
EDIT. It looks all crammed together. I tried to seperate the cells with periods..........


........A........... B
1... 3.2.........1.40
2... 5.0.........1.35
3... 5.2.........1.72
4... 4.9.........1.88
5... 3.0.........1.75
6... 3.5.........1.49

7... 5.2
8... 1.72
 
Use the lookup function to create an array, i.e.

In A8 enter the formula =LOOKUP(A7,A1:B6)

That should do it, it'll use the value in A7 to lookup its pair value in the 2d array.

You owe me a beer my friend!
 
Mitzi
I still can't seem to get this to work. When I enter the your formula, for some reason, it just gives me the # in cell b6 no matter what the # in cell A7 is. Not sure if that makes sense.


So, regarding my example, I want it to give me the # in cell B3.

I'm sure it's just me doing something wrong.

Thanks for your help and I'll glady repay you with an ice cold beverage of your choice.
de
 
I'll take a look at it now...give me a second.

BTW - I'm using Excel 2002 - what version you using? Check the help file and see if the lookup function is supported.
 
I understand what you are trying to achieve, I've just tried it again and it works fine here.

A7 is =MAX(A1:A6)
A8 is =LOOKUP(A7,A1:B6)

Just tried it with your data and A8 becomes 1.72
 
Well, I just fugred out what I was doing wrong. In my example I wanted A7 to be MAX but for some reason when I type dit into excel I told it to SUM a1 to a6.
I knew it was me.
Thank you so much.
BTW do you know of a forum geared towards excel or office in general in case I have future questions?
de
 
No, I don't know any good Excel sites - I'm pretty familiar with it 'cos I use it in work all the time.

Now about the drink, please send one crate of ice cold budwieser to....😀
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top