| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Having trouble with vlookup and match
Thanks for your help!, I got it!!!!!!!! "bpeltzer" wrote: Sorry; that should read: IF spaces and/or strings are the issue... "bpeltzer" wrote: #N/A indicates that the contents of A2 weren't found anywhere in column A on sheet2. Are you confident that that's NOT the case? Is it possible that either the data in sheet1!A2 or the corresponding entry in column A of sheet2 has spaces before or after, or perhaps one is text and the other numeric? Spaces and/or strings are the issue, which has the spaces and which doesn't? Which is numeric and which isn't? "ADiscrete1" wrote: If column a has a limited # of phone numbers in 1 sheet and in the 2nd sheet I have those numbers embedded with many others as well as additional information in columns b,c,d,... = how do I pull the data in columns b,c,d,... only associated with the phone numbers in sheet 1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tricky ... Pullout related rows that match a single word using Vlookup | Excel Discussion (Misc queries) | |||
| can vlookup be forced to make a case sensitive match? | Excel Discussion (Misc queries) | |||
| is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
