VLOOKUP/LOOK Advice

[Martin.R]

Hi there,

I have 2 problems relating to LOOKUP.
Not sure if Excel can perform these calculations as they could get to complex.

Problem 1
Can it be possible to have excel look at data from one cell reference another cell then display the results from the cell next to it in another cell, sort of example:

Tab 1 (Never changes)
A B
Bob 1
Jon 2
Fred 3

Tab 2 (Dynamic, changes each week)
A B
Jon
Fred
Bob

So it would work as follows.
Tab2 column B will take Tab2 column A’s data check Tab1 column A and display Tab1 column B’s result.

Problem 2

Weekly league rank table that shows position movements week by week
Example.

Week1
1 Jon
2 Bob
3 Fred

Week2
1 Fred Up 2
2 Bob Not Moved
3 Jon Down 2

Can Excel calculate/show the actual movements of league positions?

Thanks in advance to any help anybody can offer, I am no way an Excel expert so sorry if I gave poor examples.

Martin.R

[EdMac]

Your first roblem can be overcome using a VLOOKUP.

Not sure I understand the second.

If you can attach a copy of your spreadsheet with some notes detailing whatr you want to achieve, someone is sure to be able to help.

Regards

[TIPPYS]

For your fist question if you name your data on sheet 1 something like roster (select all the included columns and Insert/name/define give it a name and click ok) then in tab 2 in column b you could use something like this

=VLOOKUP(A2,roster,2)

[shg]

Martin, please read the Forum Rules about thread titles before starting your next thread.

[Martin.R]

Your first roblem can be overcome using a VLOOKUP.

For your fist question if you name your data on sheet 1 something like roster (select all the included columns and Insert/name/define give it a name and click ok) then in tab 2 in column b you could use something like this

=VLOOKUP(A2,roster,2)

Thanks sorted that one.

My 2nd problem is, thinking of best way to describe it, a week by week rank list.
Along with each new position in the rank list I want to try and show how many rank positions a person has moved up or down.

Thanks again for your help.

[EdMac]

If you attach a copy of your sheet showing your data layout and what you want to achieve it will be easier to assist you.

[Martin.R]

If you attach a copy of your sheet showing your data layout and what you want to achieve it will be easier to assist you.

I have attached a basic version of my file.
As you can see each week a new report gets added.
I want to try and find away to have the weekly movement of games automated rather than manually change them.

Thanks in advance for any help

[EdMac]

Hi Martin

have a look at the attached and see if it does what you want

I have changed the ranking presentation.

Regards