Lookup Function
Author Message
Lookup Function

I'm attemtping to do a lookup function in a workbook with the following
details.

I have a unique number value in column B on sheet 1, i want to lookup
that value in sheet 2 column A and return the value in the same row from
column H and place that value in the same row of the Column B value but
in the columnAM.

Can this be done?  If so how?  It has been years since i was into
lookups and the brain is very cloudy.  I've tried everything I can think

Tam

Sat, 04 Jun 2005 08:39:41 GMT
Lookup Function
put this in colum  AM
=VLOOKUP(B3,Sheet2!\$A\$3:\$H\$15,8,FALSE)

Dave

Quote:
> I'm attemtping to do a lookup function in a workbook with the following
> details.

> I have a unique number value in column B on sheet 1, i want to lookup
> that value in sheet 2 column A and return the value in the same row from
> column H and place that value in the same row of the Column B value but
> in the columnAM.

> Can this be done?  If so how?  It has been years since i was into
> lookups and the brain is very cloudy.  I've tried everything I can think
> of....now I'm asking the experts!

> Tam

Sat, 04 Jun 2005 09:28:33 GMT
Lookup Function
unfortunately all i get is the #n/a error when I tried this. Perhaps I'm using
the wrong numbers?

The  colum i am searching the information for Colum A on sheet 2 has a range
of information from a25 to a271

The information that i want to appear in AM is located in sheet 2, cell range
h25:h271

Tam

Quote:

> put this in colum  AM
> =VLOOKUP(B3,Sheet2!\$A\$3:\$H\$15,8,FALSE)

> Dave

> > I'm attemtping to do a lookup function in a workbook with the following
> > details.

> > I have a unique number value in column B on sheet 1, i want to lookup
> > that value in sheet 2 column A and return the value in the same row from
> > column H and place that value in the same row of the Column B value but
> > in the columnAM.

> > Can this be done?  If so how?  It has been years since i was into
> > lookups and the brain is very cloudy.  I've tried everything I can think
> > of....now I'm asking the experts!

> > Tam

--

Mrs Tamara McCloskey
School of Medicine
James Cook University
TOWNSVILLE QLD 4811
Phone 61-7-4781-5025
Fax 61-7-4781-6986
http://www.jcu.edu.au/school/medicine/

Sat, 04 Jun 2005 10:38:12 GMT
Lookup Function
Put this in AM2 and then drag fill it down the column.

=VLOOKUP(B2,Sheet2!\$A\$25:\$H\$271,8,FALSE)

This looks for an exact match.  If the match is not made, it returns #N/A

Regards,
Tom Ogilvy

Quote:
> unfortunately all i get is the #n/a error when I tried this. Perhaps I'm
using
> the wrong numbers?

> The  colum i am searching the information for Colum A on sheet 2 has a
range
> of information from a25 to a271

> The information that i want to appear in AM is located in sheet 2, cell
range
> h25:h271

> Tam

> > put this in colum  AM
> > =VLOOKUP(B3,Sheet2!\$A\$3:\$H\$15,8,FALSE)

> > Dave

> > > I'm attemtping to do a lookup function in a workbook with the
following
> > > details.

> > > I have a unique number value in column B on sheet 1, i want to lookup
> > > that value in sheet 2 column A and return the value in the same row
from
> > > column H and place that value in the same row of the Column B value
but
> > > in the columnAM.

> > > Can this be done?  If so how?  It has been years since i was into
> > > lookups and the brain is very cloudy.  I've tried everything I can
think
> > > of....now I'm asking the experts!

> > > Thanks in advance.

> > > Tam

> --

> Mrs Tamara McCloskey
> Administrative Officer - Student Selection
> School of Medicine
> James Cook University
> TOWNSVILLE QLD 4811
> Phone 61-7-4781-5025
> Fax 61-7-4781-6986
> http://www.jcu.edu.au/school/medicine/

Sat, 04 Jun 2005 11:16:37 GMT
Lookup Function
Look for VLOOKUP in online help for a detailed explaination of the arguments
to the function, or use the function wizard to help you with the args.

Basically, the first argument is the value or cell that holds the value you
want to find in the left column of the "table_array" that has a minimum size
of A25:H271 on Sheet2, according to your specifications. The second arg is
this tabel_array. The third is the column in the table_array from which you
want a value returned. The last arg should be False if you want a value
returned only on exact matches. Remember to make your table_array reference
absolute (\$A\$25:\$H\$271). Enter the formula in AM25 (or whereever you want it
to start), then fill down.

Quote:
> unfortunately all i get is the #n/a error when I tried this. Perhaps I'm
using
> the wrong numbers?

> The  colum i am searching the information for Colum A on sheet 2 has a
range
> of information from a25 to a271

> The information that i want to appear in AM is located in sheet 2, cell
range
> h25:h271

> Tam

> > put this in colum  AM
> > =VLOOKUP(B3,Sheet2!\$A\$3:\$H\$15,8,FALSE)

> > Dave

> > > I'm attemtping to do a lookup function in a workbook with the
following
> > > details.

> > > I have a unique number value in column B on sheet 1, i want to lookup
> > > that value in sheet 2 column A and return the value in the same row
from
> > > column H and place that value in the same row of the Column B value
but
> > > in the columnAM.

> > > Can this be done?  If so how?  It has been years since i was into
> > > lookups and the brain is very cloudy.  I've tried everything I can
think
> > > of....now I'm asking the experts!

> > > Thanks in advance.

> > > Tam

> --

> Mrs Tamara McCloskey
> Administrative Officer - Student Selection
> School of Medicine
> James Cook University
> TOWNSVILLE QLD 4811
> Phone 61-7-4781-5025
> Fax 61-7-4781-6986
> http://www.jcu.edu.au/school/medicine/

Sat, 04 Jun 2005 11:14:36 GMT

 Page 1 of 1 [ 5 post ]

Relevant Pages