Lookup
 

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.

Lookup
 

http://theofficeexperts.com/downloads.htm

here's a link to an VLOOKUP example workbook


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=542747

Lookup
 

You want Vlookup, as in:

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

--
Regards,
Fred


"Rafa" wrote in message
ups.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.

Lookup
 

Hi Rafa,

See also Debra Dalgleish's VLppokup tutorial at:

http://www.contextures.com/xlFunctions02.html


---
Regards,
Norman


"Rafa" wrote in message
ups.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.