How to write a Formula

Archived from groups: microsoft.public.pocketpc (More info?)

Hello from Steved. I have Acer Pocket PC n10.

I would like to know how I would write a formula for the
below please.

In Sheet2 named "Audit Team" I have Employee Number Col A
In Sheet2 named "Audit Team" I have Surnames in Col B

In Sheet1 Cell D6 I would The formula would look in
Cell E6 and the employee number I type in would find
Surname

As an example Cell E6 would have 10021 in D6 it would
return Smith.

Thankyou

Archived from groups: microsoft.public.pocketpc (More info?)

Hello From Steved

Thankyou Damian.

Yes You have helped me.

The issue with me Damian is that I have just got this
Pocket PC and one has to think limitations in how one
goes about writing formulas, as an example the PC excel
will recognize WEEKDAY where as the Pocket PC will not.
Very interesting.

once again Thankyou.

>-----Original Message-----
>> would like to know how I would write a formula for the
>>below please.
>
>Basicly what your describling is a vertical lookup
>
>on your Audit team sheet you will need 3 columns
Employee number, Forname
>and surname eg
>
>0001 John Smth
>0002 Fred Bloggs
>
>On your second sheet in D6 as you said use the lookup
function as below
>
>=VLOOKUP(E6,'Audit team'!A2:C3,3)
>
>This looks up what is in e6 (a employee number your
trying to find the name
>for) from the Audit teamn sheet, compare it against the
data the the range
>where you've stored your employee numners and names and
diplay whats in the
>third column. ie employee number is in column 1,
forename in column 2 and
>surname in column three.
>
>Hope this helps
>
>Damian
>
>--
>Damian Burrin
>UKRA 1159 Level 2 RSO
>EARS 1115
>http://www.ukrocketry.com
>http://www.larf-rocketry.co.uk
>
>email burrin@ntlworld.com
>email damian@ukrocketry.com
>email damian@larf-rocketry.co.uk
>"Steved" <anonymous@discussions.microsoft.com> wrote in
message
>news:2e71d01c46b7b$51f7cbc0$a401280a@phx.gbl...
>> Hello from Steved. I have Acer Pocket PC n10.
>>
>> I would like to know how I would write a formula for
the
>> below please.
>>
>> In Sheet2 named "Audit Team" I have Employee Number
Col A
>> In Sheet2 named "Audit Team" I have Surnames in Col B
>>
>> In Sheet1 Cell D6 I would The formula would look in
>> Cell E6 and the employee number I type in would find
>> Surname
>>
>> As an example Cell E6 would have 10021 in D6 it would
>> return Smith.
>>
>> Thankyou
>
>
>.
>