software

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.
theofficeexperts.com/downloads.htm

here's a link to an VLOOKUP example workbook--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=542747You want Vlookup, as in:

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

--
Regards,
Fredquot;Rafaquot; gt; wrote in message ups.com...
gt;I have two columns in one sheet (PO# and Invoice#), I have another
gt; column with the same PO# in different rows, i want to return next to
gt; this PO# that Invoice #.
gt;
gt; Somebody knows how to perform this, thanks.
gt;
Hi Rafa,

See also Debra Dalgleish's VLppokup tutorial at:

www.contextures.com/xlFunctions02.html---
Regards,
Normanquot;Rafaquot; gt; wrote in message ups.com...
gt;I have two columns in one sheet (PO# and Invoice#), I have another
gt; column with the same PO# in different rows, i want to return next to
gt; this PO# that Invoice #.
gt;
gt; Somebody knows how to perform this, thanks.
gt;