Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup
Hi everybody,
I am facing a problem. I have 2 work books. The 1st is masterlist.xls and the 2nd is source.xls. I want to check under the column "acc no" and "acc officer" of the masterlist against the source to see if there is any updates/change in "acc officer" I tried this formula in the masterlist: =VLOOKUP("XXX",[Source.xls]Sheet1!A4:E2147,2,FALSE) But my result is invalid. However it works using another self created testing work book. I have 2000 over records to check if there is any change in acc officer. Is that a better way to check using what functions instead of entering individual formula? Pls help and thanks in advance |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup
Hi
I am assuming that acc no is numeric. If that is the case, then what you are looking up should be numeric also e.g XXX not "XXX". -- Regards Roger Govier "Zen" wrote in message ... Hi everybody, I am facing a problem. I have 2 work books. The 1st is masterlist.xls and the 2nd is source.xls. I want to check under the column "acc no" and "acc officer" of the masterlist against the source to see if there is any updates/change in "acc officer" I tried this formula in the masterlist: =VLOOKUP("XXX",[Source.xls]Sheet1!A4:E2147,2,FALSE) But my result is invalid. However it works using another self created testing work book. I have 2000 over records to check if there is any change in acc officer. Is that a better way to check using what functions instead of entering individual formula? Pls help and thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |