ignore blank excel using Vlookup

[tai8]

I need to look for a record in a cell, then if found give me a record from another cell, but ignore blank cells. I tried to use vlookup but I am not sure to make it ignore blank cell. I tried the below but I am still getting blank cell
IF(ISNA(VLOOKUP(B7,'TLS detail Sep 14 - Oct 25 '!D:G,4,FALSE)),"",VLOOKUP(B7,'TLS detail Sep 14 - Oct 25 '!D:G,4,FALSE))

[alansidman]

Instead of giving us a non-working formula, please explain in detail exactly what you want to happen. What are looking for? If found, what cell to look in. A sample workbook showing what you have and then what the expected results should look like (mock it up manually). Just some sample data that is representative of your actual file will go a long way to solving this.

[tai8]

On the attached file, I am trying to find a record from column b, the range is in column I, if found give me column L, but if there is a blank cell in column L, then look for a value in column L, that matches the criteria in the range

[tai8]

Anyone, Can you please assist? with I am trying to find a record from column b, the range is in column I, if found give me column L, but if there is a blank cell in column L, then look for a value in column L, that matches the criteria in the range

[samba_ravi]

E2=LOOKUP(2,1/(($I$2:$I$2098=$B2)*($L$2:$L$2098<>"")),$L$2:$L$2098)
Try this and copy towards down

[AliGW]

Anyone, Can you please assist?

This was posted about an hour after the previous post. Please be patient!!!

Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. If you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[tai8]

It works many thanks