LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default HELP! Unknown range

Hi, I'm not sure if someone can help me.

I have this formula:
=IF(ISNUMBER(VLOOKUP($W8,actuals,X$6,FALSE)),(VLOO KUP($W8,actuals,X
$6,FALSE)),0)

The problem is that I dont know where the "acutals" are. I have
inherrieted this spreadsheet from someone who is non-contactable, and
I cannot find where the actuals are. I have loooked in the "Insert"
"Name" area and cannot find anything called "actuals" even though it
exists on the drop down box.

This is fairly urgent.... can someone please help?

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct (Range unknown, needs Search) ExcelQuestion Excel Worksheet Functions 8 May 3rd 06 07:24 AM
Unknown Rows Darren Excel Discussion (Misc queries) 2 April 7th 06 10:57 PM
Average of Unknown Range Mike Excel Discussion (Misc queries) 9 March 24th 06 03:37 PM
unknown links BorisS Excel Discussion (Misc queries) 1 November 12th 05 03:08 PM
Unknown Characters Maccas Excel Discussion (Misc queries) 1 July 30th 05 12:09 PM


All times are GMT +1. The time now is 09:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"