how do i find exact values in other excel file
 

i need to refer to files when i am doing this particular task.
the first file give me details
Item, Description, Balance Quantity, Quantity Order,Quantity to be ordered.
and the second file contains the write off item codes ie these items will
not be ordered again. both these list are generated from the system and
forwarded to me to work on. i used to do it manually before but now since the
count of the line items keeps increasing i want to simplify this process and
avoid doing it manually.
can anyone help.

how do i find exact values in other excel file
 

we dont know what you want to do or how you use these files to do it.
--
paul

remove nospam for email addy!



"jan" wrote:

i need to refer to files when i am doing this particular task.
the first file give me details
Item, Description, Balance Quantity, Quantity Order,Quantity to be ordered.
and the second file contains the write off item codes ie these items will
not be ordered again. both these list are generated from the system and
forwarded to me to work on. i used to do it manually before but now since the
count of the line items keeps increasing i want to simplify this process and
avoid doing it manually.
can anyone help.

how do i find exact values in other excel file
 

Look at VLOOKUP:

In your first file:

in Cell ???

=IF(ISNA(VLOOKUP(A2,'[Write off Items.xls]Sheet1'!$A$2:$B$100,1,0)),"
",=VLOOKUP(A2,'[Write off Items.xls]Sheet1'!$A$2:$B$100,1,0))

This will look for Item (in A2) in file Write off Items.xls and if it finds
a match, return the item number: if no match found it returns blank.

=IF(ISNA(VLOOKUP(A2,'[Write off Items.xls]Sheet1'!$A$2:$B$100,1,0))," ","To
be written off")

The above puts text "To be wriiten off" into the cell"

HTH



"jan" wrote:

i need to refer to files when i am doing this particular task.
the first file give me details
Item, Description, Balance Quantity, Quantity Order,Quantity to be ordered.
and the second file contains the write off item codes ie these items will
not be ordered again. both these list are generated from the system and
forwarded to me to work on. i used to do it manually before but now since the
count of the line items keeps increasing i want to simplify this process and
avoid doing it manually.
can anyone help.