I created a spreadsheet that will track Equipments and used a vlookup. I
have the data in another tab in the workbook and created a name in the window
for it, List.

In the other worksheet, I have the main data entry sheet. I would like when
you enter an equipment # in the first cell, the description automaticlly pops
into the next cell. This is what it looks like:

A1- Equip. # B1 - Equip description

When you enter a Number in A1 I would like the description to pop up in B1.
This is the formula I have in the cell B1, =VLOOKUP(A45,list,2,FALSE)
Like I said earlier the information is in the worksheet under a diffrent tab
(I do not know if that makes a differnce.
My problem is When I do not enter the Equip # in A1. It send an #N/A in B1.
I would like for the column to be left blank if no Equip # is used.

Please excuse me I know I might sound confusing. I am not really familar
with excel and I have gotten as far as I can reading an excel book.

I would truly appreciate any help I can get.

=IF(ISNA(VLOOKUP(A1,list,2,FALSE)),"",VLOOKUP(A1,l ist,2,FALSE))

Yoy say A1 but your formula had A45. The above will return blank if there is
no or an invalid equipment number.

"Laya" wrote:

I created a spreadsheet that will track Equipments and used a vlookup. I
have the data in another tab in the workbook and created a name in the window
for it, List.

In the other worksheet, I have the main data entry sheet. I would like when
you enter an equipment # in the first cell, the description automaticlly pops
into the next cell. This is what it looks like:

A1- Equip. # B1 - Equip description

When you enter a Number in A1 I would like the description to pop up in B1.
This is the formula I have in the cell B1, =VLOOKUP(A45,list,2,FALSE)
Like I said earlier the information is in the worksheet under a diffrent tab
(I do not know if that makes a differnce.
My problem is When I do not enter the Equip # in A1. It send an #N/A in B1.
I would like for the column to be left blank if no Equip # is used.

Please excuse me I know I might sound confusing. I am not really familar
with excel and I have gotten as far as I can reading an excel book.

I would truly appreciate any help I can get.