vlookup alphanumerics vs. index(match thingy

You could try and concantinate the first and second column with something like &. In other words create a new column to the left of your first one and put in the formula

=A1&"&"&B1

This will should give you unique values of column 1 and 2 combined. Then from anywhere you can vlookup into that table using the concantinated value that you have created. Let me know if this helps.

Hope is a good thing,

I've always said that the power of the internet is in man.

The way I've been approaching this wonderful excel forum is to try and understand everything that people are helping me with, feed a man a fish, teach a man to fish principle, hey I'm a holyman what can I say.

So I'm unfamiliar with index and it sounds like something I certainly can broaden my tool-set with. Do I need to create my list somewhere?

The index is from c2 to c1000?

Cheers,

Yes, you've been very helpful, I feel like your my guardian techangel.

Cheers,

Ok, I was tempted to assign another column to my columns, but seeing as that would exceed the redundancy factory, I will raise my melon to higher expectations.

Say I have these exact values:

Lawful Good | Lawful Good | 1
Lawful Good | Lawful Neutral | 2
Lawful Good | Lawful Evil | 3

How would I get the result from the third column if I choose from my from Lawful Good (column 1) and Lawful Neutral (column 2)?

Cheers,

Is it even possible to get a result from two different choices? heh heh

Wait, maybe I gotta put my 3d glasses on,

^_________________Lawful Good_______Lawful Neutral__________Lawful Evil
|
Lawful Good_____________3_________________2_________________1
|
Lawful Neutral___________2_________________3_________________2
|
Lawful Evil______________1_________________2_________________3

uight?

Hey being dyslexic has it's advantages, especially in this environment.

-- Didja hear about the dyslexic paranoid? He always thought he was following someone?
-- Did you hear about the dyslexic rock star........... he choked to death on his own Vimto!
-- Two dyslexic men walk into a bank shouting... “Air in the hands mother stickers this is a #uckup!”

Cheers,

Absolutely, I was just having to unlearn what I learned, the vlookup is strictly up and down whereas index is left and right.

Cheers,