| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look Up
I have two worksheets. Each one is a list of PO#'s and info running
horizontally in columns. I want to use the PO# in sheet one to pull data from worksheet two where the PO# matches. All help appreciated! Thx! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look Up
Take a look at VLOOKUP function.
"PeggyG" wrote: I have two worksheets. Each one is a list of PO#'s and info running horizontally in columns. I want to use the PO# in sheet one to pull data from worksheet two where the PO# matches. All help appreciated! Thx! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look Up
I have - thanks. Still not working.
"Toppers" wrote: Take a look at VLOOKUP function. "PeggyG" wrote: I have two worksheets. Each one is a list of PO#'s and info running horizontally in columns. I want to use the PO# in sheet one to pull data from worksheet two where the PO# matches. All help appreciated! Thx! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look Up
are u sure your PO#'s are in the same format on both sheets? is the a space
in one sheet and not the other? you can copy same PO from both sheets and put them equal together to see if you get TRUE if not you might have to use trim in your formula. "PeggyG" wrote: I have - thanks. Still not working. "Toppers" wrote: Take a look at VLOOKUP function. "PeggyG" wrote: I have two worksheets. Each one is a list of PO#'s and info running horizontally in columns. I want to use the PO# in sheet one to pull data from worksheet two where the PO# matches. All help appreciated! Thx! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
