Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |