I have a Workbook with multiple sheets.... On one sheet I have a unique
identifier which provides me with certain information and have acquired
another which gives me more, but also has the same unique identifier...

I wish to import this into the one sheet for reference, however this is not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1 being the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique
index in the main sheet.


I am however getting the error "Value not available" although doing an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

Alan,

Check that the lookup value and the unique ids are exactly the same. On a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a unique
identifier which provides me with certain information and have acquired
another which gives me more, but also has the same unique identifier...

I wish to import this into the one sheet for reference, however this is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1 being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the
unique
index in the main sheet.


I am however getting the error "Value not available" although doing an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

Bob
Sorry already tried that ...
HAve used VLOOKUP before and this has me stumped !

Thanks anyways ... open to other suggestions

"Bob Phillips" wrote:

Alan,

Check that the lookup value and the unique ids are exactly the same. On a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a unique
identifier which provides me with certain information and have acquired
another which gives me more, but also has the same unique identifier...

I wish to import this into the one sheet for reference, however this is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1 being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the
unique
index in the main sheet.


I am however getting the error "Value not available" although doing an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

Hi Alan,

Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even
if they look the same.
And, with the 4th argument as FALSE, the table (Column A) has to be sorted
ascending.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Alan" wrote in message
...
Bob
Sorry already tried that ...
HAve used VLOOKUP before and this has me stumped !

Thanks anyways ... open to other suggestions

"Bob Phillips" wrote:

Alan,

Check that the lookup value and the unique ids are exactly the same. On a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no
extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a unique
identifier which provides me with certain information and have acquired
another which gives me more, but also has the same unique identifier...

I wish to import this into the one sheet for reference, however this is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1 being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the
unique
index in the main sheet.


I am however getting the error "Value not available" although doing an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

Typo Niek:

<<"And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending"

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"Niek Otten" wrote in message
...
Hi Alan,

Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even
if they look the same.
And, with the 4th argument as FALSE, the table (Column A) has to be sorted
ascending.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Alan" wrote in message
...
Bob
Sorry already tried that ...
HAve used VLOOKUP before and this has me stumped !

Thanks anyways ... open to other suggestions

"Bob Phillips" wrote:

Alan,

Check that the lookup value and the unique ids are exactly the same. On a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no
extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a unique
identifier which provides me with certain information and have acquired
another which gives me more, but also has the same unique identifier...

I wish to import this into the one sheet for reference, however this is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1 being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the
unique
index in the main sheet.


I am however getting the error "Value not available" although doing an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

"RagDyeR" wrote in message
...
Typo Niek:

<<"And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending"

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"Niek Otten" wrote in message
...
Hi Alan,

Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even
if they look the same.
And, with the 4th argument as FALSE, the table (Column A) has to be sorted
ascending.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Alan" wrote in message
...
Bob
Sorry already tried that ...
HAve used VLOOKUP before and this has me stumped !

Thanks anyways ... open to other suggestions

"Bob Phillips" wrote:

Alan,

Check that the lookup value and the unique ids are exactly the same. On
a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no
extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a
unique
identifier which provides me with certain information and have
acquired
another which gives me more, but also has the same unique
identifier...

I wish to import this into the one sheet for reference, however this
is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1
being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the
unique
index in the main sheet.


I am however getting the error "Value not available" although doing an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

Hi RagDyeR,

I'm sure you're right. I just fail to see the typo! Please help.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"RagDyeR" wrote in message
...
Typo Niek:

<<"And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending"

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"Niek Otten" wrote in message
...
Hi Alan,

Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even
if they look the same.
And, with the 4th argument as FALSE, the table (Column A) has to be sorted
ascending.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Alan" wrote in message
...
Bob
Sorry already tried that ...
HAve used VLOOKUP before and this has me stumped !

Thanks anyways ... open to other suggestions

"Bob Phillips" wrote:

Alan,

Check that the lookup value and the unique ids are exactly the same. On
a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no
extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a
unique
identifier which provides me with certain information and have
acquired
another which gives me more, but also has the same unique
identifier...

I wish to import this into the one sheet for reference, however this
is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1
being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the
unique
index in the main sheet.


I am however getting the error "Value not available" although doing an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

I believe he meant that if the 4th argument is FALSE you won't need any
sorting


--
Regards,

Peo Sjoblom


"Niek Otten" wrote in message
...
Hi RagDyeR,

I'm sure you're right. I just fail to see the typo! Please help.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"RagDyeR" wrote in message
...
Typo Niek:

<<"And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending"

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"Niek Otten" wrote in message
...
Hi Alan,

Are both items numeric or text? Check this with =ISTEXT or ISNUMBER,
even
if they look the same.
And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Alan" wrote in message
...
Bob
Sorry already tried that ...
HAve used VLOOKUP before and this has me stumped !

Thanks anyways ... open to other suggestions

"Bob Phillips" wrote:

Alan,

Check that the lookup value and the unique ids are exactly the same. On
a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no
extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a
unique
identifier which provides me with certain information and have
acquired
another which gives me more, but also has the same unique
identifier...

I wish to import this into the one sheet for reference, however this
is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1
being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the
unique
index in the main sheet.


I am however getting the error "Value not available" although doing
an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

Glad this isn't color TV!

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Peo Sjoblom" wrote in message
...
I believe he meant that if the 4th argument is FALSE you won't need any
sorting


--
Regards,

Peo Sjoblom


"Niek Otten" wrote in message
...
Hi RagDyeR,

I'm sure you're right. I just fail to see the typo! Please help.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"RagDyeR" wrote in message
...
Typo Niek:

<<"And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending"

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"Niek Otten" wrote in message
...
Hi Alan,

Are both items numeric or text? Check this with =ISTEXT or ISNUMBER,
even
if they look the same.
And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Alan" wrote in message
...
Bob
Sorry already tried that ...
HAve used VLOOKUP before and this has me stumped !

Thanks anyways ... open to other suggestions

"Bob Phillips" wrote:

Alan,

Check that the lookup value and the unique ids are exactly the same.
On a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no
extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a
unique
identifier which provides me with certain information and have
acquired
another which gives me more, but also has the same unique
identifier...

I wish to import this into the one sheet for reference, however this
is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1
being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the
unique
index in the main sheet.


I am however getting the error "Value not available" although doing
an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

Actually, it is Niek.
In my O.E., watched messages are red,
So ... since you're watched, you're RED!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Niek Otten" wrote in message
...
Glad this isn't color TV!

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Peo Sjoblom" wrote in message
...
I believe he meant that if the 4th argument is FALSE you won't need any
sorting


--
Regards,

Peo Sjoblom


"Niek Otten" wrote in message
...
Hi RagDyeR,

I'm sure you're right. I just fail to see the typo! Please help.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"RagDyeR" wrote in message
...
Typo Niek:

<<"And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending"

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"Niek Otten" wrote in message
...
Hi Alan,

Are both items numeric or text? Check this with =ISTEXT or ISNUMBER,
even
if they look the same.
And, with the 4th argument as FALSE, the table (Column A) has to be
sorted
ascending.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Alan" wrote in message
...
Bob
Sorry already tried that ...
HAve used VLOOKUP before and this has me stumped !

Thanks anyways ... open to other suggestions

"Bob Phillips" wrote:

Alan,

Check that the lookup value and the unique ids are exactly the same.
On a
matching item, do a LEN(C3) and LEN(Ax) to see that there are no
extraneous
spaces in there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...
I have a Workbook with multiple sheets.... On one sheet I have a
unique
identifier which provides me with certain information and have
acquired
another which gives me more, but also has the same unique
identifier...

I wish to import this into the one sheet for reference, however
this
is
not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1
being
the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of
the
unique
index in the main sheet.


I am however getting the error "Value not available" although
doing
an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan

I have had this same type of problem before. Hopefully you don't do the same
stupid things I do but,

Have you tried it with the Equation having true in the last spot to just
make sure the sheet references are correct?
Have you tried something like
= match((C3,WorkNo!A2:B8200,0) to see if it recognizes the identity in other
than Vlookup
I had one workbook I inherited, in which that the Vlookup never did work and
I had to use the equivelent of
=index(WorkNo!A2:B8200,Match(C3,WorkNo!A2:AB8200,0 )


"Alan" wrote:

I have a Workbook with multiple sheets.... On one sheet I have a unique
identifier which provides me with certain information and have acquired
another which gives me more, but also has the same unique identifier...

I wish to import this into the one sheet for reference, however this is not
performing as expected.

THe sheet I am trying to copy from has 2 columns of data column 1 being the
unique index and column 2 being the data to be copied

I have used a VLOOKUP function on the main page viz:
=VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique
index in the main sheet.


I am however getting the error "Value not available" although doing an
individual find on the other sheet finds it is there ???

Any help greatfully appreciated

Alan