| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
I have a spreadsheet with a worksheet with several thousand physician names,
addresses, etc. In another worksheet in the same file I have a list of about 200 zip codes. I need to pull all of the physicians from worksheet 1 that have office addresses in the zip codes in worksheet 2. I tried using VLOOKUP but I'm doing something wrong and it's not working. Can someone tell me if VLOOKUP is the best function to use and how to use it for this situation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
