Dear all, I have this situation:

RATENAME | DAY1 | DAY2 | DAY3 | DAY4
myrate | 200 | 200 | | |
myrate | | | 250 | 250 |
... and so on

in a separte worksheet I would like to have:

RATENAME | DAY1 | DAY2 | DAY3 | DAY4
myrate | 200 | 200 | 250 | 250 |
.... and so on

so basically compressing the list in the first worksheet to one row in
second worksheet.

My problem is that vlookup only looks up the first result it finds,
even if the field is empty (see screenshots). I would instead need it
to find the first numerical value, as I am only itnerested in this.

This is the vlookup I am currently using:

=IF(ISERROR(VLOOKUP($A5,EFI!$B$3:$GK$1500,23,FALSE )),0,VLOOKUP($A5,EFI!$B$3:$GK$1500,23,FALSE))

Thank you for any help you can give me..

Titus.


+-------------------------------------------------------------------+
|Filename: excel-problem2.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=2996 |
+-------------------------------------------------------------------+

--
titushanke
------------------------------------------------------------------------
titushanke's Profile: http://www.excelforum.com/member.php...o&userid=19997
View this thread: http://www.excelforum.com/showthread...hreadid=345841