Could someone have a look at this vlookup code for me please?

z-score

I'm a noob for Excel, below is the vlookup code I have got so far.

=VLOOKUP(I1,Final!$D$2:$D$510,11,FALSE)

I'm wanting to look up the value in I1 in another spreadsheet called Final, in the region D2:D510. The return value is in the 11th column in the spreadsheet Final. I'm getting #REF! at the moment. Any help is greatly appreciated. Thank you.

purplefog

数错了吧？再仔细数数？

z-score

估计是,觉得syntax没错,我再看看.谢谢purplefog.

ps. What are you and missmia, yifan doing this Friday?

purplefog

原帖由 z-score 于 2009-6-30 11:28 发表
I'm a noob for Excel, below is the vlookup code I have got so far.

=VLOOKUP(I1,Final!$D$2:$D$510,11,FALSE)

I'm wanting to look up the value in I1 in another spreadsheet called Final, in the regi ...

我再仔细看了看，怎么都是同一个column呢？都是D？

z-score

原帖由 purplefog 于 2009-6-30 11:40 发表

我再仔细看了看，怎么都是同一个column呢？都是D？

I'm looking in just one column.

purplefog

原帖由 z-score 于 2009-6-30 11:47 发表


I'm looking in just one column.

then should you use rlookup instead of vlookup?

KKO

Your Table arrey is from: D2-D520, it doest make sense what you are trying to look up.
it needs to be at least 2 columns of table arrey.

PS,"The return value is in the 11th column in the spreadsheet Final" it needs to be the number of column where your table arrey is included.

z-score

原帖由 purplefog 于 2009-6-30 11:52 发表

then should you use rlookup instead of vlookup?

Oh I see, thank you. Man, I'm so useless at Excel. For this job I have to use Excel.

z-score

原帖由 KKO 于 2009-6-30 11:53 发表
Your Table arrey is from: D2-D520, it doest make sense what you are trying to look up.
it needs to be at least 2 columns of table arrey.

PS,"The return value is in the 11th column in the spreadshe ...

Oh I see, thank you very much KKO......

米虫宝宝

楼上说得对啊，怎么只有一个column，至少2个，不然怎么return value

KKO

remember in the first column of your table array, should be the the values searched by lookup_value. otherwise it WONT work.

z-score

Thank you to everyone above, it's working out to be good now. :-)