vlookup table

[Louise]

hi all

i have two tables, each consisting of 3 columns
containing a store number, a store name and an allocation
number. The store number on each table is different,
however, i need to transfer the allocation number from
the third column in one table to the third column in the
other table, by matching the store name from each.

I have, therefore, created a vlookup that looks at the
first table, then refers to the lookuptable [the one with
different store numbers] and asked it to return the value
from column 2, which is the allocation.

For some reason, I can't get it to work on all of them.
Some times it returns the correct allocation number but
others it returns n/a error.

can anybody offer any urgent help??

Thank you.

Louise

 

[Bernard Liengme]

Please show us your formula
Are the items in the tables sorted?

 

[Louise]

My formula reads =VLOOKUP(F13,lookup,3)

f13 contains a store name in my original table. The same
store name is also in the LookUp table [called lookup]
but this has column number 3, containing allocation
numbers. It is the allocation number i need to return
into my original table.

I know this is confusing. If it would help, I could e-
mail it to you???

Thanks.
Louise

-----Original Message-----
Please show us your formula
Are the items in the tables sorted?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

hi all

i have two tables, each consisting of 3 columns
containing a store number, a store name and an allocation
number. The store number on each table is different,
however, i need to transfer the allocation number from
the third column in one table to the third column in the
other table, by matching the store name from each.

I have, therefore, created a vlookup that looks at the
first table, then refers to the lookuptable [the one with
different store numbers] and asked it to return the value
from column 2, which is the allocation.

For some reason, I can't get it to work on all of them.
Some times it returns the correct allocation number but
others it returns n/a error.

can anybody offer any urgent help??

Thank you.

Louise

.

 

[Frank Kabel]

Hi
use
=VLOOKUP(F13,lookup,3,FALSE)

for finding an exact match

--
Regards
Frank Kabel
Frankfurt, Germany

My formula reads =VLOOKUP(F13,lookup,3)

f13 contains a store name in my original table. The same
store name is also in the LookUp table [called lookup]
but this has column number 3, containing allocation
numbers. It is the allocation number i need to return
into my original table.

I know this is confusing. If it would help, I could e-
mail it to you???

Thanks.
Louise

-----Original Message-----
Please show us your formula
Are the items in the tables sorted?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

hi all

i have two tables, each consisting of 3 columns
containing a store number, a store name and an allocation
number. The store number on each table is different,
however, i need to transfer the allocation number from
the third column in one table to the third column in the
other table, by matching the store name from each.

I have, therefore, created a vlookup that looks at the
first table, then refers to the lookuptable [the one with
different store numbers] and asked it to return the value
from column 2, which is the allocation.

For some reason, I can't get it to work on all of them.
Some times it returns the correct allocation number but
others it returns n/a error.

can anybody offer any urgent help??

Thank you.

Louise

.

 

[Louise]

I've tried this also and it still doesn't work.

Any more ideas????

Thanks.

Louise

-----Original Message-----
Hi
use
=VLOOKUP(F13,lookup,3,FALSE)

for finding an exact match

--
Regards
Frank Kabel
Frankfurt, Germany

My formula reads =VLOOKUP(F13,lookup,3)

f13 contains a store name in my original table. The same
store name is also in the LookUp table [called lookup]
but this has column number 3, containing allocation
numbers. It is the allocation number i need to return
into my original table.

I know this is confusing. If it would help, I could e-
mail it to you???

Thanks.
Louise

-----Original Message-----
Please show us your formula
Are the items in the tables sorted?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


"Louise" <[email protected]> wrote

in
message

hi all

i have two tables, each consisting of 3 columns
containing a store number, a store name and an allocation
number. The store number on each table is different,
however, i need to transfer the allocation number from
the third column in one table to the third column in the
other table, by matching the store name from each.

I have, therefore, created a vlookup that looks at the
first table, then refers to the lookuptable [the one with
different store numbers] and asked it to return the value
from column 2, which is the allocation.

For some reason, I can't get it to work on all of them.
Some times it returns the correct allocation number but
others it returns n/a error.

can anybody offer any urgent help??

Thank you.

Louise


.

.

 

[Frank Kabel]

Hi
what does happen excatly when you tired it?

--
Regards
Frank Kabel
Frankfurt, Germany

I've tried this also and it still doesn't work.

Any more ideas????

Thanks.

Louise

-----Original Message-----
Hi
use
=VLOOKUP(F13,lookup,3,FALSE)

for finding an exact match

--
Regards
Frank Kabel
Frankfurt, Germany

My formula reads =VLOOKUP(F13,lookup,3)

f13 contains a store name in my original table. The same
store name is also in the LookUp table [called lookup]
but this has column number 3, containing allocation
numbers. It is the allocation number i need to return
into my original table.

I know this is confusing. If it would help, I could e-
mail it to you???

Thanks.
Louise
-----Original Message-----
Please show us your formula
Are the items in the tables sorted?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


hi all

i have two tables, each consisting of 3 columns
containing a store number, a store name and an allocation
number. The store number on each table is different,
however, i need to transfer the allocation number from
the third column in one table to the third column in the
other table, by matching the store name from each.

I have, therefore, created a vlookup that looks at the
first table, then refers to the lookuptable [the one with
different store numbers] and asked it to return the value
from column 2, which is the allocation.

For some reason, I can't get it to work on all of them.
Some times it returns the correct allocation number but
others it returns n/a error.

can anybody offer any urgent help??

Thank you.

Louise


.

.

 

[Louise]

It simply returns the answer as N/A for all of them,
whereas I know it should have returned a value. I've
done severa lookup tables before and can't understand why
this one won't work??

I know people don't like receiving e-mail but would it be
of any use if I mailed the workbook to you? It's only
small.

THanks.

Louise

-----Original Message-----
Hi
what does happen excatly when you tired it?

--
Regards
Frank Kabel
Frankfurt, Germany

I've tried this also and it still doesn't work.

Any more ideas????

Thanks.

Louise

schrieb im
Newsbeitrag

My formula reads =VLOOKUP(F13,lookup,3)

f13 contains a store name in my original table. The same
store name is also in the LookUp table [called lookup]
but this has column number 3, containing allocation
numbers. It is the allocation number i need to return
into my original table.

I know this is confusing. If it would help, I could e-
mail it to you???

Thanks.
Louise
-----Original Message-----
Please show us your formula
Are the items in the tables sorted?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


hi all

i have two tables, each consisting of 3 columns
containing a store number, a store name and an allocation
number. The store number on each table is different,
however, i need to transfer the allocation number from
the third column in one table to the third column in the
other table, by matching the store name from each.

I have, therefore, created a vlookup that looks at the
first table, then refers to the lookuptable [the one with
different store numbers] and asked it to return the value
from column 2, which is the allocation.

For some reason, I can't get it to work on all of them.
Some times it returns the correct allocation number but
others it returns n/a error.

can anybody offer any urgent help??

Thank you.

Louise


.


.

.

 

[Frank Kabel]

Hi
o.k send it

--
Regards
Frank Kabel
Frankfurt, Germany

It simply returns the answer as N/A for all of them,
whereas I know it should have returned a value. I've
done severa lookup tables before and can't understand why
this one won't work??

I know people don't like receiving e-mail but would it be
of any use if I mailed the workbook to you? It's only
small.

THanks.

Louise

-----Original Message-----
Hi
what does happen excatly when you tired it?

--
Regards
Frank Kabel
Frankfurt, Germany

I've tried this also and it still doesn't work.

Any more ideas????

Thanks.

Louise
-----Original Message-----
Hi
use
=VLOOKUP(F13,lookup,3,FALSE)

for finding an exact match

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag My formula reads =VLOOKUP(F13,lookup,3)

f13 contains a store name in my original table. The same
store name is also in the LookUp table [called lookup]
but this has column number 3, containing allocation
numbers. It is the allocation number i need to return
into my original table.

I know this is confusing. If it would help, I could e-
mail it to you???

Thanks.
Louise
-----Original Message-----
Please show us your formula
Are the items in the tables sorted?

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


hi all

i have two tables, each consisting of 3 columns
containing a store number, a store name and an allocation
number. The store number on each table is different,
however, i need to transfer the allocation number from
the third column in one table to the third column in the
other table, by matching the store name from each.

I have, therefore, created a vlookup that looks at the
first table, then refers to the lookuptable [the one with
different store numbers] and asked it to return the value
from column 2, which is the allocation.

For some reason, I can't get it to work on all of them.
Some times it returns the correct allocation number but
others it returns n/a error.

can anybody offer any urgent help??

Thank you.

Louise


.


.

.