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!