2 Questions 1 about Macro, 1 about VLookup
 

Hell All,

So, here are my questions,

I know how to use VLOOKUP. However, is it possible to do the lookup
for information in 2 cells on the same row, and only return a match is
both cells match 2 cells in the list. eg. I have a list with names,
and apartment number. I want to look for the names in a large
spreadsheet, but since there may be many John Smiths on the list, I
want to make sure I find the one from apartment 109. Can this be
done.

Also, I have recorded a macro. The macro basically copies the entry
from a cell in a list, into the search box, and then searches for the
the entry on a different, larger worksheet. However, the macro
searches for the same name. I can't get the macro to copy the next
names in the list. Can this be done, that it will go down the list and
search for each name in the list?

Any help is greatly appreciated.

Michael


--
wiredwrx
------------------------------------------------------------------------
wiredwrx's Profile: http://www.excelforum.com/member.php...o&userid=21145
View this thread: http://www.excelforum.com/showthread...hreadid=550072