Vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJW - 07 Feb 2008 15:48 GMT

I am trying to use a vlookup to find a id number from a range of cells and
if found have it insert the data form the column 2. It seems to be working
but it is not pulling the exact number. here is my formula.
=VLOOKUP(E6,$BM$2:$BN$22,2)

Column E6 contains all the Id numbers
The array also has the id's with a Grade in column 2
How can I make it pull the exact number that is looking up.

Thanks for your Time

Reply to this Message

Don Guillett - 07 Feb 2008 15:57 GMT

If not sorted by number use ,0 or ,false at the end. Look in the help index
for VLOOKUP
=VLOOKUP(E6,$BM$2:$BN$22,2,0)

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>I am trying to use a vlookup to find a id number from a range of cells and
> if found have it insert the data form the column 2. It seems to be
[quoted text clipped - 7 lines]
>
> Thanks for your Time

Reply to this Message

JJW - 07 Feb 2008 16:19 GMT

Can i also reference the array from another sheet within the workbook

> If not sorted by number use ,0 or ,false at the end. Look in the help index
> for VLOOKUP
[quoted text clipped - 11 lines]
> >
> > Thanks for your Time

Reply to this Message

Don Guillett - 07 Feb 2008 16:42 GMT

if you mean
=VLOOKUP(E6,othersheetname!$BM$2:$BN$22,2,0)
or
=VLOOKUP(othersheetname!E6,$BM$2:$BN$22,2,0)

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Can i also reference the array from another sheet within the workbook
>
[quoted text clipped - 15 lines]
>> >
>> > Thanks for your Time

Reply to this Message

CLR - 07 Feb 2008 16:01 GMT

=VLOOKUP(E6,$BM$2:$BN$22,2,FALSE)

Vaya con Dios,
Chuck, CABGx3

> I am trying to use a vlookup to find a id number from a range of cells and
> if found have it insert the data form the column 2. It seems to be working
[quoted text clipped - 6 lines]
>
> Thanks for your Time

Reply to this Message