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

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)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JJW" wrote in message
...
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

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

Vaya con Dios,
Chuck, CABGx3



"JJW" wrote:

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

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

"Don Guillett" wrote:

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)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JJW" wrote in message
...
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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JJW" wrote in message
...
Can i also reference the array from another sheet within the workbook

"Don Guillett" wrote:

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)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JJW" wrote in message
...
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