Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two vlookup questions | Excel Worksheet Functions | |||
VLOOKUP questions | Excel Worksheet Functions | |||
Vlookup and few more questions :) | Excel Worksheet Functions | |||
VLOOKUP - 2 Questions | Excel Worksheet Functions | |||
VLOOKUP Questions | Excel Worksheet Functions |