formula: is it possible?

A

afdmello

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
 
B

Bob Phillips

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)
 
A

afdmello

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 said:
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 said:
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
Click to expand...
Click to expand...
 
P

Pete_UK

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

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?




Us VLKOOKUP
Click to expand...
=VLOOKUP(A2,'[other workbook.xls]Forums'!$C:$D,2,FALSE)
Bob
Click to expand...

(there's no email, no snail mail, but somewhere should be gmail in my
addy)
Click to expand...

- Show quoted text -
Click to expand...
 
Top