Not to sure

[Steved]

Hello from Steve Dee

Below is on Sheet 1 would like a formula on Sheet 2
Ok I want a lookup please that would copy the data in Col C to Sheet 2

A B C
1 Orewa Man 17/223 11
2 Man 22/240 2
3 Man SG240 7
4 Nissan SCORP-SLF180 6

Thankyou.

[Steved]

Hello From Steved

If you push Reply on my first post You will see the layout.

Thankyou.

"Steved" wrote:

> Hello from Steve Dee
>
> Below is on Sheet 1 would like a formula on Sheet 2
> Ok I want a lookup please that would copy the data in Col C to Sheet 2
>
> A B C
> 1 Orewa Man 17/223 11
> 2 Man 22/240 2
> 3 Man SG240 7
> 4 Nissan SCORP-SLF180 6
>
> Thankyou.
>

[Bob Phillips]

We don't get Reply in the NGs

=VLOOKUP("Orewa Man",Sheet1!A1:C100,3,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steved" <[email protected]> wrote in message
news:[email protected]...
> Hello From Steved
>
> If you push Reply on my first post You will see the layout.
>
> Thankyou.
>
> "Steved" wrote:
>
> > Hello from Steve Dee
> >
> > Below is on Sheet 1 would like a formula on Sheet 2
> > Ok I want a lookup please that would copy the data in Col C to Sheet 2
> >
> > A B C
> > 1 Orewa Man 17/223 11
> > 2 Man 22/240 2
> > 3 Man SG240 7
> > 4 Nissan SCORP-SLF180 6
> >
> > Thankyou.
> >