advice on maybe using web query

dhx10000

Board Regular
Joined
Jul 11, 2005
Messages
144
Hi everyone,

I need advice on the best way to conquer my latest problem, I'm thinking maybe using a web query. Anyway, I have a worksheet where Column K, contains our users names (lastname, first). I am trying to populate another column with the appropriate email for each person. The only way I can think of getting that data is by doing a query using the web interface of our LDAP.

So I would like to take the value from column K and stick it in here:

http://ldap.directory.myCompany.com/cgi-bin/DS/search.cgi?search_type=CommonName&search_string=[ValueFromColumnK]&listing=short

then hopefully, create a loop that will populate each cell with the appropriate email to look like this:

Column K Email Column
Doe, John johnd@co.com
Doe, Jane janed@co.com
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
in the absece of data this can only be a vaue suggstions

download the email data from your company webpae on sheet 1

on sheet2 in column A you can enter the names you are interested in and in column B use vlookup function. this will pick up the appropriate email address pertaining to the name in coumn A from sheet 1. if necessary see help under <vlookup>
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,920
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top