View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default looking up data in another column

Hi,
Sorry, I just realized the similarity of this posting and mine. Could
you help me too?

I have copied part of the post here for you...


..This is the first time I have ever posted a question on the internet,
..so bear with me, I will do my best to be clear and concise for anyone
..who may be interested in helping me look good to my boss! :))

..Seems the easiest way to do this is tell you what I need the formula
to
..do, so here goes...


..User Facing I would like to see two columns, #1 is 'Req. Number' and
..#2, is 'Position'. In order to streamline data as well as to save
..time on data entry, a user would only need to enter a desired req.
..number into column 1 of the row they are working on. The formula I am

..looking for would be able to then take that number, reference
..previously entered (possibly hidden) data, and then be able to report
....
..I KNOW excel can do this. It has to be one of the most basic things
it
..does, yet I can no longer sift through all these commands knowing that

..someone out there knows that this is a cinch. If that person is you,
..dear reader, please take pity on the girl who is still working at 9:00

..on a friday night and at least give me a hint?

It occurs to me that I may be able to figure out how to work the
previously posted formult to my use, but after trying to figure it out
on my own for so long before coming here for help, I feel as if my
brain is melting! (eew) Meaning, I don't think I would get very far
with such a venture tonight.


Please just let me know if you can help me.

THANK YOU! Even if you can't help, thanks for at least attempting to
by reading this.


MANDA
San Jose, CA
Okay, so like I said, I've never done this...do I leave my e-mail for
quickest response?


-- too late now I guess!