ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - VLOOKUP (https://www.excelbanter.com/new-users-excel/80963-vlookup.html)

gordo

VLOOKUP

Hi,
Can someone please help me. I am using Vlookup to look up a table and
bring nack relevant information. When the information is not found
vlookup returns N/A.
Is there any way of vlookup returning an empty cell if no info is found

Rgds

Gordon

Ardus Petus

VLOOKUP

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(....))

HTH
--
AP

"gordo" a écrit dans le message de
ups.com...
Hi,
Can someone please help me. I am using Vlookup to look up a table and
bring nack relevant information. When the information is not found
vlookup returns N/A.
Is there any way of vlookup returning an empty cell if no info is found

Rgds

Gordon

RODY

VLOOKUP

=IF(ISNA(VLOOKUP(DATA)),"NO INFO",VLOOKUP(DATA))

"gordo" wrote:

Hi,
Can someone please help me. I am using Vlookup to look up a table and
bring nack relevant information. When the information is not found
vlookup returns N/A.
Is there any way of vlookup returning an empty cell if no info is found

Rgds

Gordon

All times are GMT +1. The time now is 12:01 AM.