#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 390
Default Vlookup vs index

I have the 3 columns of data in columns "m", "n", and "o" (No headings, data
starts in row 1). There are 216 rows starting in row 1. From the example
below, I will create in column "r", the heading FB2. Under the heading, I
want to
see each 3 digit number that corresponds to FB2, with out repeating the same
3 digit number.
M N O p Q
R
000 0.198407405 PO3 FB2
001 0.207502916 CV3
002 0.984589896 CV3
003 0.715903627 FB2

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 390
Default Vlookup vs index



"Bill" wrote:

I have the 3 columns of data in columns "m", "n", and "o" (No headings, data
starts in row 1). There are 216 rows starting in row 1. From the example
below, I will create in column "r", the heading FB2. Under the heading, I
want to
see each 3 digit number that corresponds to FB2, with out repeating the same
3 digit number.
M N O p Q R

000 0.198407405 PO3 FB2
001 0.207502916 CV3
002 0.984589896 CV3
003 0.715903627 FB2

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Vlookup vs index

See your other post

--
Biff
Microsoft Excel MVP


"Bill" wrote in message
...
I have the 3 columns of data in columns "m", "n", and "o" (No headings,
data
starts in row 1). There are 216 rows starting in row 1. From the example
below, I will create in column "r", the heading FB2. Under the heading, I
want to
see each 3 digit number that corresponds to FB2, with out repeating the
same
3 digit number.
M N O p Q
R
000 0.198407405 PO3 FB2
001 0.207502916 CV3
002 0.984589896 CV3
003 0.715903627 FB2



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
Index/Match or Vlookup S Excel Worksheet Functions 2 September 1st 08 04:21 AM
VLOOKUP or maybe INDEX mpenkala Excel Worksheet Functions 2 April 19th 08 05:05 AM
Should I use VLOOKUP? IF? INDEX? Susan Excel Worksheet Functions 4 March 13th 08 02:02 PM
VLOOKUP, INDEX, or ....? Mac Excel Worksheet Functions 1 October 15th 07 12:54 PM
INDEX? VLOOKUP? lloydyleg11 Excel Discussion (Misc queries) 2 November 14th 06 04:35 AM


All times are GMT +1. The time now is 12:27 AM.

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"