CODEWITHSUNDEEP
excelexcel-formula
revolutionkpi
revolutionkpi

Reputation: 2682

How to find value of a cell from named range

Is in EXCEL some formala, that can find value of a cell. Something like INDEX, but instead of an index column, a named range.

I want to find cell in this named range and i know index of row

Upvotes: 2

Views: 16257

Answers (2)

chris neilsen
chris neilsen

Reputation: 53126

Just use INDEX as you would normally, and specifiy the name rather than the range, eg if YourNamedRange names the range A1:A100 then

=INDEX(YourNamedRange, IndexNumber)

and

=INDEX(A1:A100, IndexNumber)

are equivalent

Upvotes: 5

Carlos Raúl Gómez
Carlos Raúl Gómez

Reputation: 61

for vba range("YourNamedRange").cells(1,1) will get you the value of the first cell in the range

Upvotes: 0

Related Questions