Previous Topic Next Topic

Lookup last name in a range

Solved/Closed
StormDronk - May 17, 2010 at 06:22 AM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
StormDronk
May 17, 2010 at 07:49 AM
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Stormdronk
May 17, 2010 at 09:02 AM
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
Stormdronk
May 17, 2010 at 10:15 AM
Hi, dit you come right with the download??
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 17, 2010 at 10:33 AM
Ok I am lost what this has to do with look up ?
0

Similar discussions

Find my Gmail account
Dabang -
HelpiOS -

1 response
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
Lookup table? Excel
jplp123 -
rizvisa1 -

1 response
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses
keyboard shortcut for Smart Lookup
informatiquetique123 -
informatiquetique123 -

4 responses