MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Naming Cells


Posted by Jenny on December 08, 2001 10:13 AM

I know this is going to seem like a silly question, but...

I want to name A:B "Support" so that I can use that name in a VLookup.

Also, if I store that list n a different workbook, is there an easy way to lookup using this name without having to go through all the VLookup steps?

Thanks


Posted by jack on December 08, 2001 3:42 PM

Name a group/single cells is easy enough
Select the chosen cells A:B hightlight the all
Click intsert from the toolbar
Click name
Clicj Define
default will be these select cells
Call the group Support and press enter
You have named that group

refer to it as Support not A:B you might need to limit the rows to X say A1:B1000 just so the group is reasonable in size

2nd question, No excel or VLOOKUP stinks and yes you need to go via the normal VLOOKUP functin syntax to get the answer, im working in custon function VLOOKUP so its easier, but still same rule apply
=Vlookup(A1,Sheet1!.....