get past one problem, and run across another

R

rjmckay

Ok...

I got my vlookup tables all set up.... all working... only one proble
now...

I have one instance where $33 is used twice

so I have a $33 that's worth 2 points and a $33 worth 3 points.

so on the table of course it reads

33 2
33 3

and of course, when it looks it up, it looks up the first instance o
33 .

So is there a way to solve this without messing up the numbers? I
there a way of saying... oh hey, it's 33 .... do you want 2 or 3?

I can't think of a way of doing it... but then that's why I'm askin
out there, there are you guys who are a lot smarter or more experience
than I am.

Thank you
 
M

mrice

Not sure about smarter....

If you created a third column which contained the concatentated valus
for the first two, you could use this to find a unique value.

e.g. in C1 have the formula A1 & B
 
R

rjmckay

Toppers said:
What determines whether it is 2 or 3?
Click to expand...

$33 - 2 units
$33 - 3 units

$33 for a different age groups and different price schedules. As
rule I've been able to sort by prices ... and not have to worry abou
this, however, in this case, $33 repeats itself for 2 differen
things.

I've been trying to avoid adding any more to the page, as frankly I'
running out of maximum page use. ... however, I'm working on an ide
now... where I'm using up the very last bit of page space to sort ou
this problem, hopefully it will wor
 
Top