新西兰天维网社区

标题: Could someone have a look at this vlookup code for me please? [打印本页]

作者: z-score 时间: 2009-6-30 11:28:40 标题: Could someone have a look at this vlookup code for me please?

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 时间: 2009-6-30 11:32:41

数错了吧？再仔细数数？

作者: z-score 时间: 2009-6-30 11:37:37 标题: 回复 2# purplefog 的帖子

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

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

作者: purplefog 时间: 2009-6-30 11:40:29

原帖由 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 时间: 2009-6-30 11:47:57

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

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

I'm looking in just one column.

作者: purplefog 时间: 2009-6-30 11:52:32

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

I'm looking in just one column.

then should you use rlookup instead of vlookup?

作者: KKO 时间: 2009-6-30 11:53:55

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 时间: 2009-6-30 12:04:02

原帖由 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 时间: 2009-6-30 12:04:24

原帖由 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......

作者: 米虫宝宝 时间: 2009-6-30 12:05:21

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

作者: KKO 时间: 2009-6-30 12:18:41

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

作者: z-score 时间: 2009-6-30 14:45:04

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

欢迎光临新西兰天维网社区 (http://bbs.skytrade.co.nz/)