 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
Issues with VLOOKUP
I have a column of randomly ordered stimuli names, corresponding to 16 different places, with 4 directions each
1_ne 13_sw 8_sw 11_se etc. There are 64 total. Each correspond to a single number, 1-64, where: 1_ne is 1 1_nw is 2 1_se is 3 1_sw is 4 2_ne is 5 etc etc All I want to do it use a lookup function to search this key array and return the corresponding number. I am using =VLOOKUP(C1,$G$1:$H$64,2) Which I thought would work, but it is not always returning the correct number. For example, it returns "3" for 1_se and "12" for 3_sw and several others, but then also returns "4" for 11_ne and "63 for 9_sw. What am I doing wrong? Is there a better way to approach this task? |
||||
Check out some similar questions!
Limitations of VLOOKUP
[ 3 Answers ]
I have a column of values that can't be put in ascending order. 20 55 3 61 2 etc. I want to lookup another value that corresponds to each of these numbers.
Errection issues or Attraction issues
[ 3 Answers ]
Folks! - I have a problem. I'm 26, my girlfriend is 20 - We both hold eastern values (for the most part) and I've been with her for about 1 year now - we've been having regular sex everyday pretty much for about 8/9 months now - and by regular sex I mean sex every day, sometimes couple of times...
CD Issues
[ 2 Answers ]
OK, so I put a CD in and all it does is make a weird noise a couple times and not read the CD! I have Windows XP and it shows up that there's no CD in the Drive, what the hells going on?
View more questions Search
| Question Tools | Search this Question |
Add your answer here.
|
