Formulae-Number entered, but name is displayed.

[Ozpwc]

Real new to all this stuff.
I tried 'IF' formulae but friend said try HLOOKUP/VLOOKUP but no joy!!

In Spreadsheet, I need to have a formulae so that when a number, eg 1, is entered a name associated with that number is displayed.

Thanks for the help.
Ozpwc.

[James3359]

I'm not quite clear what you are trying to achieve here. I assume that you want to put a numeric value in one cell, and have that to cause a name to be shown in another cell. How you do this will depend on a number of factors. If you only have a few values to deal with then you can do it with a nested IF formula:

[sardisson]

[Ozpwc]

James, you seem to know your stuff !!
However, I must be doing something wrong, as I get name/522error mesg.

To clarify further;
I to be able to enter range of numbers(1-10) in a cell ,then have corresponding names(Bob(1),Peter(2),Bill(3),Steve(4)) to those numbers displayed "in that same particular cell".??

Sorry if were going over same stuff >>>
Cheers Peter.

[ovvldc]

No, not in that same cell.

If you want Bob, Peter, Bill or Steve in that cell without referring anywhere else, you need to enter the names there. The formulae work on what is in other cells.

best wishes,
Oscar

[yoxi]

Not that it's a perfect solution, but you could always have the numbers in e.g. column D and the lookup results in column E, and then hide column D.

What you want to do (if I understand correctly) is to display a 'virtual' value in a cell whilst keeping the real value hidden underneath it. It may be possible to do that via some very sophisticated conditional formatting. Or do you just want to replace the number value with the name value? That should be possible via a macro. But it's a lot easier to go with the column hiding thing .

[James3359]

[James3359]

Another way which may get near to what you want is to use the data validation feature. Select the cell into which you wish to insert the data and choose Data>Validity. In the Validity diaolog select the Criteria tab and choose List in the drop-down menu. In the Entries field enter the list of names that can be entered each separated by a return. Uncheck Allow blank cells if you don't want to allow them and leave Show Selection list checked.

Your cell will now have a little button to the right of it. Clicking that button brings down the list of names you entered and the user can choose which name they want using keyboard or mouse.

[Ozpwc]

Ok, too hard to understand all your words/phrases, so here is spreadsheet presentation of what I am trying to do-I think??

Here's the DRAW for numerous tennis teams,by their Team Numbers;

Rnd DATE Team Team Team Team
1 05/Feb 3 v 8 5 v 6 7
2 12/Feb 2 v 7 4 v 5 6
3 19/Feb 1 v 6 3 v 4 6

[Ozpwc]

Disregard previous mesg!!

Ok, too hard to understand all your previous mesg's or the NeoOffice Help, so here is spreadsheet presentation of what I am trying to do-I think??

Here's the DRAW for our tennis teams,displayed as Team Numbers;

Rnd DATE Team Team Team Team
1 05/Feb 3 v 8 5 v 6
2 12/Feb 2 v 7 4 v 5
3 19/Feb 1 v 6 3 v 4

I want to re-type DRAW in a spreadsheet so that as I type each 'TEAM Nº' the team NAME is presented instead of the Team Nº .
I have tried Lookup & Vlookup but cant get the desired result or formulae???
Thnks in advance
Ozpwc.

[Jim]

See if this is what you're looking for.