Convert text to named range

chinglnc

Board Regular
Joined
Nov 5, 2013
Messages
132
Hi

How do I convert text to named range?

For example, I have set a named range as 'fruit'

B2= fruit

So the formula would look like vlookup(a1, namedrange(b2), xx, xx)

How do I convert B2 so that it becomes a named range rather than a text?

Please help.

Thanks
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,967
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top