Hello All, I have another syntax Question for you coders

cyote101

Active Member
Joined
Dec 11, 2004
Messages
315
I have Cells of Data
Name Date
1 | Jerry | |
2 | billy | | _________
3 | | | |____2_____| This cell is called "Key"
4 | | |
5 | | |
6 | | |


The colom with the numbers is called "Reff" the "Name" at the top is "Name" and the colome with the "Date" at the top is "Date"


Now I have some other cells with fomulas in them "=Lookup(Key,reff,name)

What is suposed to do is serch the "reff" Colum find "2" (as shown in Cell "Key" and retunr the value in the "Name Column'' in this Case "Billy" and when you change the number in "Key" cell it would continue to work the same way.

Now I have used this funtion 100s of times in the past and for soome reason this time it does not work.

any help on this would be helpful.


Thanks
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

vconfused

Well-known Member
Joined
Jun 11, 2004
Messages
547
Sounds right. You could also use a vlookup, but what is the formula returning now?
 

cyote101

Active Member
Joined
Dec 11, 2004
Messages
315
Whell It's Very wierd

When the number "1" is in the "Key" Cell it works but when you put 2 in there instead of finding "2" and then returning the right value. It does not do anything


... I don't know the Vlookup Funtion and the glossery is in "Greek" could you explain it to me. for make one that does this funtion and I'll retrofit it.



Thanks
 

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
The numbers, do they equal or go even with the row numbers somehow? Like:

1__1
2__2
3__3

or

1__3
2__4
3__5

because you can just return the value associated with the rownumber.

take a look at this:
Map3
DEFG
4a
5b
6c
7d7g
8e
9f
10g
Blad1
 

cyote101

Active Member
Joined
Dec 11, 2004
Messages
315
Question: how did you paste your work book in the messege?

And I'm not sure I know what I'm Looking at, please explain your argument

thanks
 

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
what I mean is, do the numbers 'count' ? are they starting with 1, 2, 3 .. until the end of the list? or, can the number be produced in a random order? (ie. 6, 2, 4, 1)
 

Forum statistics

Threads
1,148,218
Messages
5,745,444
Members
423,952
Latest member
EduardoM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top