Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Formula help
I am trying to import comments from source file to destination file. commer
column is Invoice # column. In souce file I sorted records as per invoice #, destination file is as it is. Destination file is more comprehensive than source file, it has more invoices than source file. Problem - in destination file, formula imports values for which there is no invoice # ( look up value) in the source file. Example = I have 5 invoice in source file and I have one column( comments column) to which I want to export to other file(destination file). Destination file has 10 invoices but doesnt have comments so like to do vlook up based on invoice numbers. I wrote vlook up formula for 1st invoice, imported correct comments from source file. Then I did copy paste of formula for other 4 invoices then it gave me correct values, thenafter I did copy paste of formula for other 5 invoices in destination file( these invoices are not there in source file), so I should get err but I got comments imported to from other invoices. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Formula help
The Range value determines the type of search. TRUE = Approximate Match,
FALSE = Exact Match. Try putting FALSE at the end of your arguement. "Vlook up" wrote: I am trying to import comments from source file to destination file. commer column is Invoice # column. In souce file I sorted records as per invoice #, destination file is as it is. Destination file is more comprehensive than source file, it has more invoices than source file. Problem - in destination file, formula imports values for which there is no invoice # ( look up value) in the source file. Example = I have 5 invoice in source file and I have one column( comments column) to which I want to export to other file(destination file). Destination file has 10 invoices but doesnt have comments so like to do vlook up based on invoice numbers. I wrote vlook up formula for 1st invoice, imported correct comments from source file. Then I did copy paste of formula for other 4 invoices then it gave me correct values, thenafter I did copy paste of formula for other 5 invoices in destination file( these invoices are not there in source file), so I should get err but I got comments imported to from other invoices. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup Formula | Excel Discussion (Misc queries) | |||
Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
vlookup formula | Excel Worksheet Functions |