Lookup

[Rafa]

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.

 

[davesexcel]

http://theofficeexperts.com/downloads.htm

here's a link to an VLOOKUP example workbook

 

[Fred Smith]

You want Vlookup, as in:

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

 

[Norman Jones]

Hi Rafa,

See also Debra Dalgleish's VLppokup tutorial at:

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