display cell data in relation to previous cell.

**liamthebof** · 05-27-2007, 01:44 PM

OK i am trying to display a name in a cell due to the number in the cell next to it.

e.g

A B
1 person1 500
2 person2 250
3 person3 340
4 person4 700
5
6
7 highest score: =max(B1:B4)
8 scored by (what code here=to display person4)

what code needed in cell B8 to display the person who has the highest score shown in the cell above.

Is this possible with vlookup?

Thanks in Advance

**VBA Noob** · 05-27-2007, 01:57 PM

Try

=INDEX(A1:A4,MATCH(A7,B1:B4,0))

OR

=INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0))

VBA Noob

**liamthebof** · 05-27-2007, 02:11 PM

Ok thanks, it works now.
BTW does vlookup only work if the names\score were the opposite way round?

**VBA Noob** · 05-27-2007, 02:18 PM

Here is some info on Vlookup

http://www.contextures.com/xlFunctions02.html

VBA Noob

**liamthebof** · 05-27-2007, 02:25 PM

OK seeing as you are an excel uber,

ok i have a set of numbers vertical enetered in cells.
below these i have =average(a1:a7)
i have a few columns like this.
before i add figures to be averaged i get #DIV/0! in the cell. this chages when i add numbers in cells above. Is there any way to just display 0 is this cell?

EDIT!

No worries, ISERROR, solved above problem

display cell data in relation to previous cell.

LinkBack

Thread Tools

Rate This Thread

Display

display cell data in relation to previous cell.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions