See
http://support.microsoft.com/default.aspx?scid=268948
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
|
| Ah I see what you are thinking and obviously my message wasn't very clear!
|
| I've cracked it I created a name range for the two columns individually and
| couldn't get it to work but have just created a named range for the whole
| lot and now it works
|
| I wanted a web form that searches an excel spreadsheet the same as you can
| do with an access database. Insert>Database>Results etc
|
| Thanks Anyway
|
| Cheers
| Shona
|
|
| | > Yes, you posted it in the wrong newsgroup. This newsgroup is for
| > FrontPage.
| > Look for an Excel newsgroup.
| > --
| > Tom [Pepper] Willett
| > Microsoft MVP - FrontPage
| > "You're a daisy if you do!"
| > ---
| > FrontPage Support:
| >
http://www.frontpagemvps.com/
| > ===
| > | > : Think I posted this in the wrong one as there only appears to be one
| > other
| > : message!
| > :
| > : Is this possible I only have two columns in the spreadsheet I want to be
| > : able to put in the information from one cell and return the results from
| > the
| > : same cell in the next column?
| > :
| > : Cheers
| > : Shona
| > :
| > :
| >
| >
|
|