Regarding updating 1000 values using vlookup from another worksheet

[VirusKid]

Hi,
i have a worksheet naming table_p_source with two columns, resource query string value and page source.

Another worksheet naming, main_spread_sheet containing several columns, but two columns are identical to table_p_source. One is the resouce query string value and the other, page source.

Using the vlookup method, the resource query string value column is supposed in main_spread_sheet is supposed to link up with table_p_source of the resource query string value column for the datas allocated in the page source column.

The problem i'm facing now is that, with vlookup, i am able to update datas single rows at a time. With 1000 rows and datas to update, how is it possible? for e.g. vlookup=(B6,Table_psource!$B$2:$C260,2)

This is the formula, which i dun understand why it could not update all the rows in it, but instead, only gave one.

[Toppers]

VLOOKUP can only return one value which your case is the page_source value
corresponding to the resource query string in B6.

Simply copy the formula down for your 1000 rows and they will updated.

=Vlookup(B6,Table_psource!$B$2:$C$260,2,false))

To allow for an error use:

=IFf(ISNA(Vlookup(B6,Table_psource!$B$2:$C$260,2,false)),"",Vlookup(B6,Table_psource!$B$2:$C$260,2,false))

This will leave a blank cell if there no match.

HTH



"VirusKid" wrote:

>
> Hi,
> i have a worksheet naming table_p_source with two columns, resource
> query string value and page source.
>
> Another worksheet naming, main_spread_sheet containing several columns,
> but two columns are identical to table_p_source. One is the resouce
> query string value and the other, page source.
>
> Using the vlookup method, the resource query string value column is
> supposed in main_spread_sheet is supposed to link up with
> table_p_source of the resource query string value column for the datas
> allocated in the page source column.
>
> The problem i'm facing now is that, with vlookup, i am able to update
> datas single rows at a time. With 1000 rows and datas to update, how is
> it possible? for e.g. vlookup=(B6,Table_psource!$B$2:$C260,2)
>
> This is the formula, which i dun understand why it could not update all
> the rows in it, but instead, only gave one.
>
>
> --
> VirusKid
> ------------------------------------------------------------------------
> VirusKid's Profile: http://www.excelforum.com/member.php...o&userid=36425
> View this thread: http://www.excelforum.com/showthread...hreadid=561965
>
>