Re: Help! Probably dumb newbie question but need help with if/then??

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Vlookup should do what you want.

Check out this web page of Debra Dalgleish on the function:

http://www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"excel-idiot" <excel-idiot@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:45229890-1C3A-4025-BC9F-05224EC9EACD@xxxxxxxxxxxxxxxx
Thanks in advance to anyone that can help. I have looked through many
other
posts and don't quite think I am asking the right search questions. Here
goes:

Lets say I am creating a schedule and when I type in an employee number in
A1 how do I get excel to then enter data that I specify (name, skills,
whatever) in subsequent cells (b2, b3, etc)???



.

Relevant Pages

  • Re: VLOOKUP AND #N/A
    ... Please keep all correspondence within the NewsGroup, ... I tried 3 other answers given in the archives first but still haven't been ... I'm looking for for an exact match to A6 in column H of my VLOOKUP table ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Substituting values
    ... Sounds like Vlookup should work for you. ... Check out this site of Debra Dalgleish on this function: ... Please keep all correspondence within the NewsGroup, ...
    (microsoft.public.excel.misc)
  • Re: Create a dropdown
    ... Debra Dalgleish has a web site that can get you started on this. ... Please keep all correspondence within the NewsGroup, ...
    (microsoft.public.excel.misc)
  • Re: spread sheets vlookup
    ... Check out this web page of Debra Dalgleish that should help you: ... Please keep all correspondence within the NewsGroup, ... function but dont know what i am doing wrong someone please help me ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Data Retrieval
    ... Check out this web page of Debra Dalgleish on the subject: ... Please keep all correspondence within the NewsGroup, ... In the first cell I want to put the job# and have it retrieve the job name ...
    (microsoft.public.excel.misc)