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