open All Channels
seplocked EVE Technology Lab
blankseplocked (Help >.<?) UPDATED: Vlookup Issue >.>
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Faqhaqt
Posted - 2011.04.18 04:25:00 - [1]
 

Edited by: Faqhaqt on 18/04/2011 20:56:57
Edit: So I figured I'd use my old thread instead of making another. After getting such quick help, albeit over something stupid, I figured I'd ask here again. I'm having an issue using the Vlookup function with Google docs. Below is the line I'm using:

=VLOOKUP('Mineral Prices and isk/M3 char'!$R2;$Q$2:$S$100;3,false)

When entered though, it says "Error, did not find the value x) -x is whatever value I ask it to lookup. I've tried different things, same error-

This doesn't make sense to me. It's saying " Error, I can't find -Tritanium- " when I am asking it to find Tritanium, and Tritanium is within the columns I gave it. The line above uses three columns, but before I was using two and had the same error.

Any idea what to do? Thanks for the help in advance. <3

Temar Radeik
Intergalactic Syndicate
Nulli Secunda
Posted - 2011.04.18 04:30:00 - [2]
 

I tried that address in my browser and got

500 Internal Server Error

The server encountered an unexpected condition which prevented it from fulfilling the request.

Faqhaqt
Posted - 2011.04.18 04:41:00 - [3]
 

Originally by: Temar Radeik
I tried that address in my browser and got

500 Internal Server Error

The server encountered an unexpected condition which prevented it from fulfilling the request.
That's weird... I get a document tree with the market data.


Temar Radeik
Intergalactic Syndicate
Nulli Secunda
Posted - 2011.04.18 04:50:00 - [4]
 

there was an & missing between 34 and usesystem

Faqhaqt
Posted - 2011.04.18 04:56:00 - [5]
 

Originally by: Temar Radeik
there was an & missing between 34 and usesystem
Oh my God I'm so embarrassed.

I'm sorry for wasting your time over something so stupid. Thanks a ton for the help >.>

Brutal Concussion
Posted - 2011.04.18 20:57:00 - [6]
 

Edited by: Brutal Concussion on 18/04/2011 21:01:15
Updated with new issue, hoping for help. Thanks a ton guys <3


Edit: Whoops wrong char >.>

Lutz Major
Posted - 2011.04.19 07:56:00 - [7]
 

Originally by: Faqhaqt
=VLOOKUP('Mineral Prices and isk/M3 char'!$R2;$Q$2:$S$100;3,false)


First question: Do other cells work?

If yes, quick guess:
*) 'Tritanium' is not a value of the column Q - maybe it's ' Tritanium' or 'Tritanium '?

Greg Huff
Posted - 2011.04.19 18:05:00 - [8]
 

Originally by: Faqhaqt
=VLOOKUP('Mineral Prices and isk/M3 char'!$R2;$Q$2:$S$100;3,false)
Try replacing the semi-colons with commas

=VLOOKUP('Mineral Prices and isk/M3 char'!$R2,$Q$2:$S$100,3,false)

Faqhaqt
Posted - 2011.04.20 01:39:00 - [9]
 

Originally by: Lutz Major
Originally by: Faqhaqt
=VLOOKUP('Mineral Prices and isk/M3 char'!$R2;$Q$2:$S$100;3,false)


First question: Do other cells work?

If yes, quick guess:
*) 'Tritanium' is not a value of the column Q - maybe it's ' Tritanium' or 'Tritanium '?



No, no other cell works either. It always says " Did not find value x" and X is always the exact value in the cell, that I want it to display.

Also, I found out that I can just do ='Mineral Prices and isk/m3 char'!(insert cell) and get it to display pretty much any cell that I want. I'm not exactly sure what the difference between this and the Vlookup function, so is there any reason for me to try Vlookup anymore?

Greg Huff: Switching to commas left it the same, but when I tried your format, it gave me a parse error >.<

Thank you both for your help, sorry for the long response, I was busy yesterday.

Lutz Major
Posted - 2011.04.20 07:03:00 - [10]
 

Originally by: Faqhaqt
...
Also, I found out that I can just do ='Mineral Prices and isk/m3 char'!(insert cell) and get it to display pretty much any cell that I want. I'm not exactly sure what the difference between this and the Vlookup function, so is there any reason for me to try Vlookup anymore?
...

Uhm ... well ... ahh ... if that's what you wanted, then it's okay to use the reference ... I guess Rolling Eyes

Sidrat Flush
Caldari
Eve Industrial Corp
Posted - 2011.04.20 13:43:00 - [11]
 

Originally by: Lutz Major
Originally by: Faqhaqt
...
Also, I found out that I can just do ='Mineral Prices and isk/m3 char'!(insert cell) and get it to display pretty much any cell that I want. I'm not exactly sure what the difference between this and the Vlookup function, so is there any reason for me to try Vlookup anymore?
...

Uhm ... well ... ahh ... if that's what you wanted, then it's okay to use the reference ... I guess Rolling Eyes


The difference between vlookup across a range of cells and a specific cell is for integrity management. If you're looking for the M3 of x but x changes rows for whatever reason then it will tell you the m3 of something totally different.

All you need to manage is the range and the column reference, although that should get updated if the named range changes, I know that's the case for excel at least.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only