V-Lookup issues

[TommyD]

hi all,
having some issues with v look-up. I have two sets of data in tw
worksheets within the same workbook. The first list is the data set
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 eac
worksheet and they are both set to numbers. Either i get N/A as a valu
9if i put in false), or when i copy it down, once I find a value jus
repeating for all the numbers. what's the deal? help

 

[Ashish Mathur]

Hi,

May I request you to mail me the workbook at (e-mail address removed) and
explain the problem very clearly.

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

 

[pdberger]

TommyD --

It would help to have the formulas to look at.

pdb

 

[Spiky]

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!

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.