excel LOOKUP( ) error

A

apples

=LOOKUP(AG5,'Regular Invoices'!A:A,'Regular Invoices'!E:E)

AG 'Regular Invoice' 'Regular
Invoices'
A
E
041000-1 041000-1 SEIU
041000-2 041000-2 WP
041001-1 041001-1 SEIU

Regular Invoices is a data input worksheet where column A is the
invoice number and column E is the client code

column AG comes from a formula worksheet. rather than crowding report
worksheets with complicated formula and extraneous information I placed
them on a extra worksheet at the end and report worksheets are linked
through there.

it would seem like this has gone out of its way to complicate things,
but the invoice number needs to be on the formula worksheet for user
reference.

what confuses me is that this LOOKUP works fine in rows
6,7,8,9,.....but not in row 5 (first row of data)

any thoughts?
 
Top