RE: look up word

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Big Rob <BigRob@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 18 Aug 2008 21:38:00 -0700

I have tried VLOOKUP but this also does not allow me to use alfa numeric
inputs in the lookup cell, If I used a straight number it wooks fine
returning a work in the cell but not lookup a word and returning a different
word based on the first word.

Big Rob

"Gary''s Student" wrote:

Consider using =VLOOKUP()
--
Gary''s Student - gsnu200800

"Big Rob" wrote:

I am trying to input a word into one cell I want to auto generate the
contents of another cell based on the first input.
I can use Lookup if the first input is a number but this does not seem to
work if the first input is a work or alfa numeric.

Follow-Ups:
- RE: look up word
  - From: Gary''s Student
- Re: look up word
  - From: Dave Peterson

References:
- look up word
  - From: Big Rob
- RE: look up word
  - From: Gary''s Student

Prev by Date: RE: formula auditing toolbar items disabled
Next by Date: Re: =IF(AND... function
Previous by thread: RE: look up word
Next by thread: Re: look up word
Index(es):
- Date
- Thread

Relevant Pages

RE: look up word
... Gary''s Student - gsnu200800 ... "Big Rob" wrote: ... returning a work in the cell but not lookup a word and returning a different ... I can use Lookup if the first input is a number but this does not seem to ...
(microsoft.public.excel.misc)
Re: look up word
... Big Rob wrote: ... returning a work in the cell but not lookup a word and returning a different ... I can use Lookup if the first input is a number but this does not seem to ...
(microsoft.public.excel.misc)
look up word
... I am trying to input a word into one cell I want to auto generate the ... I can use Lookup if the first input is a number but this does not seem to ...
(microsoft.public.excel.misc)
RE: look up word
... "Big Rob" wrote: ... contents of another cell based on the first input. ... I can use Lookup if the first input is a number but this does not seem to ...
(microsoft.public.excel.misc)
Re: Vlookup problem
... In the adjacent cell, look to see if it returned an error. ... "Dave Peterson" wrote: ... I set the lookup formula in enquiry.xls to lookup the tel nos. ... The enquiry.xls is with the vlookup formula to lookup the data in data.xls. ...
(microsoft.public.excel.misc)