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: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=531148

Hi 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 "How do I type a number?"

Take a look a
VLOOKUP Worksheet Function
http://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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rookie robert" <rookie wrote in message
...
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?