Name Box

  • Thread starter Thread starter Nicola
  • Start date Start date
N

Nicola

Hello

I want to mark a cells group of cells in the name box but
I need to included spaces in the naming, does anyone know
how to enter names with spaces.

Or can I use an IF Formulae statement so that i.e

Ian =KLM
John =BA
Colin =KLM
Gemma =VGN
Ian =VGN
Vijay =VGN

and so forth?

Thank you.
 
A range name can't contain spaces, but you could use an underscore to
separate the words, e.g.: Range_Name

For your example, you would enter the names and codes on a blank area of
the workbook. Then, use a VLookup formula to return the correct value.
For example: =VLOOKUP(D2,$A$2:$B$7,2,0)
 
Back
Top