PC Review


Reply
Thread Tools Rate Thread

Lookup problem in Excel 2003

 
 
abentleyg38@gmail.com
Guest
Posts: n/a
 
      4th Apr 2012
I had a formula in an Excel workbook called Payments to update the bank balance during 2011-2012:

=LOOKUP(1E+100,'\\Pfadc01\company data\ADMINISTRATION\Excel\Accounts 2011-2012\Bank 11-12\[2011-2012 Bank balance.xls]PF'!$F:$F)

This worked perfectly well until I needed a similar formula for 2012-2013. I have amended it as appropriate but it only returns 0.00 on my Payments sheet.

This is the formula I am using:
=LOOKUP(1E+100,'\\Pfadc01\company data\ADMINISTRATION\Excel\Accounts 2012-2013\Bank 12-13\[2012-2013 Bank balance.xls]PF'!$F:$F)

Can anyone see where I have gone wrong please? Help would be greatly appreciated!
 
Reply With Quote
 
 
 
 
joeu2004
Guest
Posts: n/a
 
      5th Apr 2012
<(E-Mail Removed)> wrote:
> I had a formula in an Excel workbook called Payments
> to update the bank balance during 2011-2012:
> =LOOKUP(1E+100,'\\Pfadc01\company data\ADMINISTRATION\
> Excel\Accounts 2011-2012\
> Bank 11-12\[2011-2012 Bank balance.xls]PF'!$F:$F)
>
> This worked perfectly well until I needed a similar
> formula for 2012-2013. I have amended it as appropriate
> but it only returns 0.00 on my Payments sheet.
> This is the formula I am using:
> =LOOKUP(1E+100,'\\Pfadc01\company data\ADMINISTRATION\
> Excel\Accounts 2012-2013\
> Bank 12-13\[2012-2013 Bank balance.xls]PF'!$F:$F)
>
> Can anyone see where I have gone wrong please?


Quite possibly nowhere.

The formula returns the last numeric value in column F. Presumably, 0.00 is
the last numeric value.

If you want the last non-zero numeric value, you can use the following
normal-entered formula (just press Enter as usual) if the last non-empty
cell contains a numeric value, not text.

=LOOKUP(1E+100,1/('\\Pfadc01\company data\ADMINISTRATION\
Excel\Accounts 2012-2013\
Bank 12-13\[2012-2013 Bank balance.xls]PF'!$F:$F<>0),
'\\Pfadc01\company data\ADMINISTRATION\
Excel\Accounts 2012-2013\
Bank 12-13\[2012-2013 Bank balance.xls]PF'!$F:$F)

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 David Ryan Microsoft Excel Worksheet Functions 4 15th Apr 2009 03:25 PM
Access 2003 Lookup based on Lookup previous field - populate other records on Form janine_docsonline Microsoft Access Forms 0 29th Jan 2006 11:03 AM
Lookup Lookup Lookup =?Utf-8?B?TVI=?= Microsoft Excel Worksheet Functions 2 10th Mar 2005 02:59 AM
How do I lookup and return different values when the lookup value. =?Utf-8?B?a2c=?= Microsoft Excel Misc 1 20th Jan 2005 01:53 AM
Lookup - V Lookup HELP ME Microsoft Excel Misc 12 25th Dec 2003 07:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:18 AM.