need help from Excel Pro....

  • Thread starter Thread starter Dan Brimley
  • Start date Start date
D

Dan Brimley

I have a spreadsheet with 2 worksheets. 1 worksheet has a list of numerical
codes with data in two other columns that are associated with each code.

I want to be able to enter any one of those numerical codes into the second
worksheet and have it automatically pull in the associated data to those
codes.

Can someone tell me how or point me in the right direction for information
to accomplish this.

Huge Thanks!!!
 
Dan said:
I have a spreadsheet with 2 worksheets. 1 worksheet has a list of
numerical codes with data in two other columns that are associated
with each code.

I want to be able to enter any one of those numerical codes into the
second worksheet and have it automatically pull in the associated
data to those codes.

Can someone tell me how or point me in the right direction for
information to accomplish this.

Huge Thanks!!!
Click to expand...


Depending on how your first spreadsheet is set up, you will need to use
HLOOKUP or VLOOKUP functions to get this working. Is very easy - you should
be able to figure it out using the formula creater .

If not, just post here for more help...
 
Dan,

Check out the lookup formulas (LOOKUP and VLOOKUP)
I believe their what you looking for.

ie.

On sheet 1
abc1 desc11 desc12
abc2 desc21 desc22
abc3 desc31 desc32
etc...

On sheet2 (desired)
abc2 desc21 desc22

formula to get desc21
=VLOOKUP(A1,Sheet1!A1:C3,2,FALSE)
OR
=LOOKUP(A1,Sheet1!A1:A3,Sheet1!B1:B3)
for desc22
=VLOOKUP(A1,Sheet1!A1:C3,2,FALSE)
OR
=LOOKUP(A1,Sheet1!A1:A3,Sheet1!C1:C3)

I prefer vlookup myself.

Dan E
 
Dan said:
I have a spreadsheet with 2 worksheets. 1 worksheet has a list of
numerical codes with data in two other columns that are associated
with each code.

I want to be able to enter any one of those numerical codes into the
second worksheet and have it automatically pull in the associated
data to those codes.

Can someone tell me how or point me in the right direction for
information to accomplish this.
Click to expand...

You need a LOOKUP function. Probably VLOOKUP, to be specific. Excel's help
is a great place to start now that you know the name of the function.

Dave
dvt at psu dot edu
 
=VLOOKUP(A1,Sheet1!A1:C3,{2,3},FALSE)
array entered into B1:C1 will return desc21 and desc22, respectively,
into those two cells.

Alan Beban
 
Back
Top