-
I have 2 worksheets. WkSht1 has 1 column A Client name Bob Tom WKSHT 2 has two columns Col. B has multiple client IDs per Client in Col. A A B CLIENT CLIENT ID Bob B123 B456 B789 Tom T321 T654 T987 There are variable numbers of IDs per Client I need a lookup to match on the client from WKSHT1 and retrieve...
-
I have a spreadsheet of addresses that was scanned using OCR. The scanner did an acceptable job of text recognition, however due to additional Title's (i.e. MD, PhD, RN, etc) the columns in excel became wildly unmanageable. I need to extract Telephone, Fax and E-mail from a long list of contacts...
-
Lately I've been coming across situations where I need to join one or more fields from a large dataset to another large dataset. The obvious answer is a vlookup. However, the speed of the vlookup drops dramatically the larger the datasets, which makes sense, a 100,000 row dataset being matched against...
-
Give me some insight to this problem I have a several cells that retreive data from a table via the VLookUP function; fine, no problem One of the above cells is use by another cell as the basis to lookup values in another table, which always returns #N/A. If I simply manually retype the cell value, the...