name ranges

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

Hi,
Sheet2 has the formula: =VLOOKUP($B$3,Sheet1!$B$2:$D$15,2,FALSE) in cell c8
How can I use a range name (names-1 for example) that refers to: Sheet1
range B2:B15 in a way that i have a small arrow beside cell B3 that show
all the names in the range (names-1)?
 
Please give us more detail, this question is not clear. What does VLOOKUP
have to do with the range names and what do you mean by the names in the
range names-1. And what do you mean by a small arrow which shows the names?
 
Vlookup search the vallue that I type in cell B3 sheet2.
Can I select the value that I want from the range defined in sheet1?
Hope this makes it more clear!!!!
 
Back
Top