VLOOKUP Function

[John]

Hi,

I am trying to figure out how I can perform something similar to
VLookup in Excel. For example, I have list (A) with a drop down field
that looks up a column of customer names in list (B). I want the
following columns in list (A) to populate with the correct addresses of
the selected customer; these addresses are also in list (B).

I am using Frontpage 2003 if necessary. Does anyone have an idea of how
to accomplish this. Thanks in advance.


John

 

[Stefan B Rusynko]

You will need to explain what type of server you are on, and which Extensions
If on Windows and FP SE
- then use a database of spreadsheet as a database
If on Windows and WSS
- then use a data list

PS
Please don't cross post

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


| Hi,
|
| I am trying to figure out how I can perform something similar to
| VLookup in Excel. For example, I have list (A) with a drop down field
| that looks up a column of customer names in list (B). I want the
| following columns in list (A) to populate with the correct addresses of
| the selected customer; these addresses are also in list (B).
|
| I am using Frontpage 2003 if necessary. Does anyone have an idea of how
| to accomplish this. Thanks in advance.
|
|
| John
|
|

 

[John]

The server is WSS. But I am using FrontPage to customize the site.

I can not find a VLOOKUP function for a Sharepoint List.

John

 

[Stefan B Rusynko]

Try asking in the WSS newsgroup at: news://msnews.microsoft.com/microsoft.public.sharepoint.windowsservices


PS
There is no Vlookup
- you need a data list or data part or database

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


| The server is WSS. But I am using FrontPage to customize the site.
|
| I can not find a VLOOKUP function for a Sharepoint List.
|
| John
|
|
| | > You will need to explain what type of server you are on, and which
| Extensions
| > If on Windows and FP SE
| > - then use a database of spreadsheet as a database
| > If on Windows and WSS
| > - then use a data list
| >
| > PS
| > Please don't cross post
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| | > | Hi,
| > |
| > | I am trying to figure out how I can perform something similar to
| > | VLookup in Excel. For example, I have list (A) with a drop down field
| > | that looks up a column of customer names in list (B). I want the
| > | following columns in list (A) to populate with the correct addresses of
| > | the selected customer; these addresses are also in list (B).
| > |
| > | I am using Frontpage 2003 if necessary. Does anyone have an idea of how
| > | to accomplish this. Thanks in advance.
| > |
| > |
| > | John
| > |
| > |
| >
| >
|
|