Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get exact values from a graph in Excel? | Charts and Charting in Excel | |||
find exact values of SQRT | Excel Worksheet Functions | |||
Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
using vlookup to find exact match | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions |