VLookup question

  • Thread starter Thread starter Peter Mihfjdskla
  • Start date Start date
P

Peter Mihfjdskla

I've tried searching for an answer to my question, but with no luck.

I'm working on a sheet to compare to lists of numbers, using this
formula:

=VLOOKUP(C6,A4:B392,1,TRUE)


I've tried to use a constant in the formula, but it doesn't work.
Assuming that {} defines a constant, why can't I do this?


=VLOOKUP(C6,{A4:B392},1,TRUE) so the array I need to search is
constant?
 
Peter,

You need absolute cell references ($A$4:$B$392), not relative (A4:B392).
The F4 key will switch this, if the reference is selected while you're in
Enter or Edit mode.

=VLOOKUP(C6,$A$4:$B$392,1,TRUE)

Better yet, define a name (Insert - Name - Define) for the range, then use
it in the function:

=VLOOKUP(C6, TableOfStuff, 1,TRUE)

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Back
Top