|  | formula: is it possible? | | |
| | | afdmello |  |
|  Posted: Thu Aug 21, 2008 3:54 am Post subject: formula: is it possible? |  |
I Have equipment numbers in column "D"and the relevant drawings numbers
they are in column "G". in one workbook.
In another workbook I have the equipment numbers in column "E" and the
drawing numbers are needed to be filled in Column "H". The sad part there
is no proper sequence for it and so I am copying and pasting from one book
to another.
Is there a formula that can ease my troubles?
Any help will be greatly Appreciated.
AF Dmello |
| |
| | | Bob Phillips | |
| | Posted: Thu Aug 21, 2008 5:19 am Post subject: Re: formula: is it possible? | |
Us VLKOOKUP
=VLOOKUP(A2,'[other workbook.xls]Forums'!$C:$D,2,FALSE)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"afdmello" <afdmello@hotmail.com> wrote in message
news:eIRwgJ1AJHA.1740@TK2MSFTNGP02.phx.gbl...
| Quote: |
I Have equipment numbers in column "D"and the relevant drawings numbers
they are in column "G". in one workbook.
In another workbook I have the equipment numbers in column "E" and the
drawing numbers are needed to be filled in Column "H". The sad part there
is no proper sequence for it and so I am copying and pasting from one book
to another.
Is there a formula that can ease my troubles?
Any help will be greatly Appreciated.
AF Dmello
|
|
| |
| | | afdmello | |
| | Posted: Tue Sep 02, 2008 3:23 am Post subject: Re: formula: is it possible? | |
| |  | |
I did finally succeed using VLOOKUP and the match formula combination.
Now the cells where the formula exists reference other cells in other
sheets. I want only the results displayed and do not want the formulas to
exist. Is there a way out?
The issue is the list is long and is also filtered will this cause a
problem?
AFD
"Bob Phillips" <bob.ngs@somewhere.com> wrote in message
news:eKpei41AJHA.3756@TK2MSFTNGP04.phx.gbl...
| Quote: | Us VLKOOKUP
=VLOOKUP(A2,'[other workbook.xls]Forums'!$C:$D,2,FALSE)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"afdmello" <afdmello@hotmail.com> wrote in message
news:eIRwgJ1AJHA.1740@TK2MSFTNGP02.phx.gbl...
I Have equipment numbers in column "D"and the relevant drawings numbers
they are in column "G". in one workbook.
In another workbook I have the equipment numbers in column "E" and the
drawing numbers are needed to be filled in Column "H". The sad part
there is no proper sequence for it and so I am copying and pasting from
one book to another.
Is there a formula that can ease my troubles?
Any help will be greatly Appreciated.
AF Dmello
|
|
| |
| | | Pete_UK | |
| | Posted: Tue Sep 02, 2008 9:35 am Post subject: Re: formula: is it possible? | |
| | | |
To fix the values, highlight the cells with the formula in, then click
<copy>, then Edit | Paste Special | Values (check) | OK then <Enter>.
Hope this helps.
Pete
On Sep 2, 6:23 am, "afdmello" <afdme...@hotmail.com> wrote:
| Quote: | I did finally succeed using VLOOKUP and the match formula combination.
Now the cells where the formula exists reference other cells in other
sheets. I want only the results displayed and do not want the formulas to
exist. Is there a way out?
The issue is the list is long and is also filtered will this cause a
problem?
AFD"Bob Phillips" <bob....@somewhere.com> wrote in message
news:eKpei41AJHA.3756@TK2MSFTNGP04.phx.gbl...
Us VLKOOKUP
=VLOOKUP(A2,'[other workbook.xls]Forums'!$C:$D,2,FALSE)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"afdmello" <afdme...@hotmail.com> wrote in message
news:eIRwgJ1AJHA.1740@TK2MSFTNGP02.phx.gbl...
I Have equipment numbers in column "D"and the relevant drawings numbers
they are in column "G". in one workbook.
In another workbook I have the equipment numbers in column "E" and the
drawing numbers are needed to be filled in Column "H". The sad part
there is no proper sequence for it and so I am copying and pasting from
one book to another.
Is there a formula that can ease my troubles?
Any help will be greatly Appreciated.
AF Dmello- Hide quoted text -
- Show quoted text - |
|
| |
|
|
