Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP!@#$%^&*
Dear All
i have one control sheet which contains all the details of clients according to their account no. and the amount. There is one more file which i receive on daily basis from my Central office which again contains details of some clients,now my job is to match up this data and send again with match and unmatch details to central office. Currently i am using vlookup function manually to doing this activity but at the colume increases it become very time consuming and there are chaces of error too when there are two different beneficary for same client with the same amount. Is there any macro available for it? Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming |