software

How do I type a number in my current worksheet which matches a number in the
same page but different worksheet column a and have it = the information in
column b of the same second worksheet?


are you asking for a lookup formula??--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=531148Hi Robert,

If you ask a question you have to provide clearly what you have and what you
want. Provide some clear idea of what you have, what the problem is, and how you
would solve the problem yourself without Excel.

Your question is garbled between what you have and what you want to obtain.
i.e. this does not make sense for a question he quot;How do I type a number?quot;

Take a look a
VLOOKUP Worksheet Function
www.mvps.org/dmcritchie/excel/vlookup.htm
and also some information there on INDEX and MATCH

I expect that if you used your full name, you would be taking a bit more
care in asking a question.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;rookie robertquot; lt;rookie gt; wrote in message
...
gt; How do I type a number in my current worksheet which matches a number in the
gt; same page but different worksheet column a and have it = the information in
gt; column b of the same second worksheet?