G
Guest
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.
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.