Re: Lookup

Giganews Newsgroups
Subject: Re: Lookup
Posted by:  Fred Smith (fredsmith…@yahoo.com)
Date: Tue, 16 May 2006

You want Vlookup, as in:

=vlookup(PO#,Sheet1!A:B,2,false)

--
Regards,
Fred

"Rafa" <r_ort…@umecopr.com> wrote in message
news:1147830758.912831.203…@j55g2000cwa.googlegroups.com...
>I have two columns in one sheet (PO# and Invoice#), I have another
> column with the same PO# in different rows, i want to return next to
> this PO# that Invoice #.
>
> Somebody knows how to perform this, thanks.

Replies

None

In response to

Lookup posted by Rafa on 16 May 2006