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

Lookup last name in a range
Https //accounts.google.com/sign in/v1/lookup - Guide
Apple airtag range - Guide
Lookup computer name by ip - Guide
Area code lookup - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum

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)

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.

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.

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]

Stormdronk
May 17, 2010 at 10:15 AM

Hi, dit you come right with the download??

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 ?

Similar discussions

Find my Gmail account

Lookup table? Excel

Excel Macro - Set and autofill a range?

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Excel if range of cell contain a text put a cell value in

Similar discussions

Subscribe To Our Newsletter!