D
Donald
I have two spreadsheets and would like to copy the info from one to the other
if the one cell matches the info in the other spread sheet?
if the one cell matches the info in the other spread sheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
teylyn
Donald;573208 said:I have two spreadsheets and would like to copy the info from one to th
other
if the one cell matches the info in the other spread sheet?
Take a look at VLOOKUP()
=VLOOKUP(A1,<otherspreadsheetRange>,<column>,False
B
Brian L
I do apologise for hyjacking this thread but could anyone tell me how I can
actually get this Forum to accept a question?
actually get this Forum to accept a question?
D
David Biddulph
The starting point is to realise that this is not primarily a web-based
forum, but is a Usenet newsgroup. A number of folk have web interfaces to
the newsgroup, but many of these web interfaces (including Microsoft's own)
are unreliable. If you are struggling with an unreliable web interface, try
an alternative means of accessing the newsgroup.
Newsgroup hints:
a.. http://www.cpearson.com/excel/HintsAndTipsForNewsgroupUsers.aspx
b.. http://www.michaelstevenstech.com/outlookexpressnewreader.htm
a.. (and http://aumha.org/nntp.htm for list of Microsoft Public
newsgroups)
c.. http://groups.google.com/group/microsoft.public.excel.misc
forum, but is a Usenet newsgroup. A number of folk have web interfaces to
the newsgroup, but many of these web interfaces (including Microsoft's own)
are unreliable. If you are struggling with an unreliable web interface, try
an alternative means of accessing the newsgroup.
Newsgroup hints:
a.. http://www.cpearson.com/excel/HintsAndTipsForNewsgroupUsers.aspx
b.. http://www.michaelstevenstech.com/outlookexpressnewreader.htm
a.. (and http://aumha.org/nntp.htm for list of Microsoft Public
newsgroups)
c.. http://groups.google.com/group/microsoft.public.excel.misc
B
Bob I
Press CTRL button while clicking New (bypasses your pop-up blocker)
T
teylyn
Bob said:Press CTRL button while clicking New (bypasses your pop-up blocker)
Bob: 'The Code Cage - Microsoft Office Help - Microsoft Offic
Discussion' (http://www.thecodecage.com) provides an easy to us
interface for the excel newsgroups. come have a look
B
Bob I
No thanks, I use a REAL news reader, and read the newsgroups directly.