- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- VLookup question

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

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?

- Re: VLookup question posted by Earl Kiosterud on Wed, 15 Oct 2003