"VLOOKUP??"

Don,

N doesn't have tgo come before Y, just add a final argument of FALSE

=VLOOKUP(A1,Sheet2!A12,3,False)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
Hi Dave,

Not sure in your case, but when I do that, I can blame it
on old age.....lol

Anyway, as I stated below, I found the answer thanks to
the link you put up. N has to come before Y in the
List. It's working fine now...I inserted an If
(A1="","",VLOOKUP.......... Works great now...

Again, thanks for the help.

Don


-----Original Message-----
Sorry I got my rows and columns mixed up, I think I
noticed
I was slipping yesterday when I indicated A2 when I
meant B1.

To suppress N/A errors: with default False you are
looking for
an exact match.

=IF(ISNA(VLOOKUP(...,...,...,False)),"Item not
found",VLOOKUP(...,...,...,False))

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed
Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm

wrote in message
...
hmmmmmmm.....I must be misinterpreting something
here....as I look at what I have, I have 4 columns....A
thru D, and two Rows 1 & 2. Why does the Y give me



.

Thanks again Bob,

Tried that in all combinations, works fine no matter what
the order.

A lesson I won't soon forget....

Don


-----Original Message-----
Don,

N doesn't have tgo come before Y, just add a final
argument of FALSE

=VLOOKUP(A1,Sheet2!A12,3,False)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
Hi Dave,

Not sure in your case, but when I do that, I can blame
it
on old age.....lol

Anyway, as I stated below, I found the answer thanks to
the link you put up. N has to come before Y in the
List. It's working fine now...I inserted an If
(A1="","",VLOOKUP.......... Works great now...

Again, thanks for the help.

Don


-----Original Message-----
Sorry I got my rows and columns mixed up, I think I
noticed
I was slipping yesterday when I indicated A2 when I
meant B1.

To suppress N/A errors: with default False you are
looking for
an exact match.

=IF(ISNA(VLOOKUP(...,...,...,False)),"Item not
found",VLOOKUP(...,...,...,False))

---
HTH,
David McRitchie, Microsoft MVP - Excel [site
changed
Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm

wrote in message
...
hmmmmmmm.....I must be misinterpreting something
here....as I look at what I have, I have 4
columns....A
thru D, and two Rows 1 & 2. Why does the Y give me



.



.

It should be the default :-)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Don" wrote in message
...
Thanks again Bob,

Tried that in all combinations, works fine no matter what
the order.

A lesson I won't soon forget....

Don


-----Original Message-----
Don,

N doesn't have tgo come before Y, just add a final
argument of FALSE

=VLOOKUP(A1,Sheet2!A12,3,False)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
Hi Dave,

Not sure in your case, but when I do that, I can blame
it
on old age.....lol

Anyway, as I stated below, I found the answer thanks to
the link you put up. N has to come before Y in the
List. It's working fine now...I inserted an If
(A1="","",VLOOKUP.......... Works great now...

Again, thanks for the help.

Don


-----Original Message-----
Sorry I got my rows and columns mixed up, I think I
noticed
I was slipping yesterday when I indicated A2 when I
meant B1.

To suppress N/A errors: with default False you are
looking for
an exact match.

=IF(ISNA(VLOOKUP(...,...,...,False)),"Item not
found",VLOOKUP(...,...,...,False))

---
HTH,
David McRitchie, Microsoft MVP - Excel [site
changed
Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm

wrote in message
...
hmmmmmmm.....I must be misinterpreting something
here....as I look at what I have, I have 4
columns....A
thru D, and two Rows 1 & 2. Why does the Y give me



.



.