Home |
Search |
Today's Posts |
#1
|
|||
|
|||
V-Lookup issues
hi all,
having some issues with v look-up. I have two sets of data in two worksheets within the same workbook. The first list is the data set I want to place the v-look-up in. the second set is in numerical order, no duplicates. I checked the formatting on both columns,, in each worksheet and they are both set to numbers. Either i get N/A as a value 9if i put in false), or when i copy it down, once I find a value just repeating for all the numbers. what's the deal? help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V-Lookup issues
Hi,
May I request you to mail me the workbook at and explain the problem very clearly. -- Regards, Ashish Mathur www.ashishmathur.com http://www.linkedin.com/in/excelenthusiasts "TommyD" wrote in message ... hi all, having some issues with v look-up. I have two sets of data in two worksheets within the same workbook. The first list is the data set I want to place the v-look-up in. the second set is in numerical order, no duplicates. I checked the formatting on both columns,, in each worksheet and they are both set to numbers. Either i get N/A as a value 9if i put in false), or when i copy it down, once I find a value just repeating for all the numbers. what's the deal? help! -- TommyD |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V-Lookup issues
TommyD --
It would help to have the formulas to look at. pdb "TommyD" wrote: hi all, having some issues with v look-up. I have two sets of data in two worksheets within the same workbook. The first list is the data set I want to place the v-look-up in. the second set is in numerical order, no duplicates. I checked the formatting on both columns,, in each worksheet and they are both set to numbers. Either i get N/A as a value 9if i put in false), or when i copy it down, once I find a value just repeating for all the numbers. what's the deal? help! -- TommyD |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V-Lookup issues
On Apr 24, 4:20 pm, TommyD wrote:
hi all, having some issues with v look-up. I have two sets of data in two worksheets within the same workbook. The first list is the data set I want to place the v-look-up in. the second set is in numerical order, no duplicates. I checked the formatting on both columns,, in each worksheet and they are both set to numbers. Either i get N/A as a value 9if i put in false), or when i copy it down, once I find a value just repeating for all the numbers. what's the deal? help! -- TommyD The repeating answer suggests you have your first reference like this: $A$2 It should be A2 (or perhaps $A2) to allow you to copy down properly. But you do need to post formulas or something if you want real help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Issues | Excel Worksheet Functions | |||
Speed issues | Excel Worksheet Functions | |||
PDF hyperlink issues | Excel Discussion (Misc queries) | |||
Issues with sorting | Excel Discussion (Misc queries) | |||
Lookup Issues / List Auto-Adjust | Excel Worksheet Functions |