Inconsistent results with =LOOKUP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

watkincm - 31 May 2006 14:59 GMT

Using 2 worksheets, where a match is found to the lookup value in the lookup
vector, the result vector appears to be accurate (too many rows to check them
all). However, when no match is found, the result vector either gives me a
'1' or (in one instance only) a #N/A error.
I would have expected the error rather than the '1' or am I missing something?

The formula iIn sheet "2005" =LOOKUP($B3,'2004'!B$3:B$9689,'2004'!P$3:P$9689)
Any ideas?

Signature

Mike Watkins

Reply to this Message

Michael Koerner - 31 May 2006 15:27 GMT

Your missing the correct newsgroup. You should be in the Excel NG

Signature

<>Please post all follow-up questions/replies to the newsgroup<>
<><>Email unless specifically requested will not be opened<><>
<><><>Do Provide The Version Of PowerPoint You Are Using<><><>
<><><>Do Not Post Attachments In This Newsgroup<><><>
Michael Koerner [MS PPT MVP]

| Using 2 worksheets, where a match is found to the lookup value in the lookup
| vector, the result vector appears to be accurate (too many rows to check them
[quoted text clipped - 4 lines]
| The formula iIn sheet "2005" =LOOKUP($B3,'2004'!B$3:B$9689,'2004'!P$3:P$9689)
| Any ideas?

Reply to this Message

watkincm - 31 May 2006 18:05 GMT

Must have been smokin' sumpin... sorry!

Signature

Mike Watkins

> Your missing the correct newsgroup. You should be in the Excel NG
>
[quoted text clipped - 10 lines]
> =LOOKUP($B3,'2004'!B$3:B$9689,'2004'!P$3:P$9689)
> | Any ideas?

Reply to this Message