Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 142
Default Vlookup with two results

My Vlookup formula returns the name of the person within a cost centre.
However if there are two people within the cost centre it obviously doesn't
return the second persons name.

I want to have a second Vlookup formula (in another cell) which will pick up
the name of the second person within the cost centre (there will no more than
2 people), or simply nothing if there is only 1 person within that cost
centre.

How can I do this?

Thanks in advance of your help
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default Vlookup with two results

Luke,

Usually, a filter (Advanced or Autofilter) is used when you want such a dataset. It's a
process you have to do each time, though.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Luke" wrote in message
...
My Vlookup formula returns the name of the person within a cost centre.
However if there are two people within the cost centre it obviously doesn't
return the second persons name.

I want to have a second Vlookup formula (in another cell) which will pick up
the name of the second person within the cost centre (there will no more than
2 people), or simply nothing if there is only 1 person within that cost
centre.

How can I do this?

Thanks in advance of your help



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default Vlookup with two results

there will [be] no more than 2 people

Try something like this for the 2nd instance:

A10 = lookup_value

=IF(COUNTIF(A1:A5,A10)1,LOOKUP(2,1/(A1:A5=A10),B1:B5),"")

Biff

"Luke" wrote in message
...
My Vlookup formula returns the name of the person within a cost centre.
However if there are two people within the cost centre it obviously
doesn't
return the second persons name.

I want to have a second Vlookup formula (in another cell) which will pick
up
the name of the second person within the cost centre (there will no more
than
2 people), or simply nothing if there is only 1 person within that cost
centre.

How can I do this?

Thanks in advance of your help



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
to sum up all value results from VLOOKUP Linn Excel Worksheet Functions 1 March 7th 07 03:45 AM
Displaying how many results in a vlookup Danhalawi Excel Discussion (Misc queries) 1 November 16th 06 11:47 AM
Add multiple vlookup results Dawn Excel Worksheet Functions 6 June 20th 06 10:06 PM
VLOOKUP show all results New_Man Excel Worksheet Functions 4 December 27th 05 08:17 AM
how do you add vlookup results? Anna Excel Worksheet Functions 3 March 26th 05 04:05 AM


All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"