Lookup last name in a range

Solved/Closed
StormDronk - May 17, 2010 at 06:22 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 17, 2010 at 01:57 PM
Hello,

= LOOKUP(1E+30,Sheet3!E118:E141)

I jused this formula to look up the last date of a range, but now want to change it to names but it wont work. Only work on dates or numbers. Please help??

Thanks

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 17, 2010 at 06:32 AM
For look up the data needs to be sorted, i think.

Use VLOOKUP or HLOOKUP

VLOOKUP("Joe" ,Sheet3!E118:E141, 1, false)
1
my cells have names in them, and are changed daily, added from a dropdown. Last name entered must go to top.

Dropdown
Martin
Henk
Paul


Resp Martin

Status Name Description Date
1 Martin Started development 16 May 2010
3 Henk Martin how long to comple 17 May 2010
2 Martin 2 weeks 17 May 2010

Hope this helps.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 17, 2010 at 08:41 AM
Sorry did not get you. What are you trying to do ?

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
0
Ok thanks. This is a management sheet to communicate on projects managed. The top have sheet 3 are the projects description A1-A100. Hyperlink (Exa A1) takes you to the communication sheet. This is where I need help. If status 1,2 or 3 date auto change to todays date. But previous day date must stay the same. Then the dropdown in the flag colum must lookup the last name in that range and ad the name to the top cell.

Thanks bud. This helps a lot. Took me hours do figure out the rest!!!


http://wikisend.com/download/463998/CM Work Flow.xlsx

[URL=http://wikisend.com/download/463998/CM Work Flow.xlsx]CM Work Flow.xlsx[/URL]
0
Hi, dit you come right with the download??
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 17, 2010 at 10:33 AM
Ok I am lost what this has to do with look up ?
0