VLookup question

Giganews Newsgroups
Subject: VLookup question
Posted by:  Peter Mihfjdskla (wh1y4inh…@sneakemail.com)
Date: 15 Oct 2003

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


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