LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
RAB RAB is offline
external usenet poster
 
Posts: 2
Default Problem - Lookup returning value of last cell in range when nomatch occurs

Bernd

Apologies now I've added the last parameter it seems to work.
Many Thanks
Ritchi

 
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
How to stop index match returning data where lookup cell empty Diddy Excel Worksheet Functions 4 January 18th 09 11:09 PM
Problem Returning Mulitple Lookup Values [email protected] Excel Worksheet Functions 1 September 29th 08 10:33 AM
lookup returning incorrect cell values stuartjk Excel Worksheet Functions 8 January 4th 07 09:09 AM
Returning a blank cell rather then #N/A (Lookup) Monk Excel Discussion (Misc queries) 2 January 24th 06 03:16 PM
LOOKUP returning value in cell above what I was searching for mwrfsu Excel Discussion (Misc queries) 2 September 10th 05 06:25 PM


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

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

About Us

"It's about Microsoft Excel"