Good Morning All,

I have a spreadsheet with the following columns used to trac
dependencies within projects:

A - ID field (number)
B - Name of ID (text)

thru' to

W - dependency (number - one of the IDs from col A)

I am trying to write some code that will lookup the dependency i
column a and return the value in column b

The vlookup formula would be in X1 and would look like this:

=vlookup(W1, A1:B10,2,false) - (this does work!)

How would I turn this into a nice piece of VBA?

Any help would be greatfully received!!

TIA,

MoonWeaze

--
Message posted from http://www.ExcelForum.com