THE_NEWBIE
New Member
- Joined
- May 10, 2005
- Messages
- 4
Hi there !
This is my first post on this board. As you will see, english is not the language i usually speak, so i hope you'll understand :wink:
Here's my little problem...
I'm using 2 basic sheets with 2 columns on each. On the first sheet, Column A = Numbers. Column B = Colours.
On the second sheet, i'm using the Vlookup function to find what colour matches the number i enter.
The problem is that i have 2 identical numbers, with diffrent colours associtated with. So when i'm doing the VLookup function, i only get the first (upper) colour.
My goal is to have both colours in two diffrent cells without using the "true" argument (D9 should have "yellow" written and D10 should have "black")
Here's a little example...
Your help would be greatly appreciated.
Thanks !!
-THE (FRENCH) NEWBIE
Removed by Admin
This is my first post on this board. As you will see, english is not the language i usually speak, so i hope you'll understand :wink:
Here's my little problem...
I'm using 2 basic sheets with 2 columns on each. On the first sheet, Column A = Numbers. Column B = Colours.
On the second sheet, i'm using the Vlookup function to find what colour matches the number i enter.
The problem is that i have 2 identical numbers, with diffrent colours associtated with. So when i'm doing the VLookup function, i only get the first (upper) colour.
My goal is to have both colours in two diffrent cells without using the "true" argument (D9 should have "yellow" written and D10 should have "black")
Here's a little example...
Your help would be greatly appreciated.
Thanks !!
-THE (FRENCH) NEWBIE
Removed by Admin