View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Bill is offline
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