Look up on two fields with this alternative to VLOOKUP «, Andy Wiggins, Byg Software
VLOOKUP2(lookup_value1,lookup_value2,table_array,col_index_num)
Macro based on Q59482 -- XL: Using INDEX and MATCH Against Multiple Criteria

 

=vlookup2(F10, F11, tLookupDemo, 3)
 
  ColA   ColB   ColC     3  Value look up in column 1   
  One 4  4    35  Value look up in column 2  
  Two 5  10    9  Result  
  One 6  6         
  Two Four 8    One Value look up in column 1  
  One 5  5    5  Value look up in column 2  
  3  6  18    5  Result  
  3  5  15         
  33  5  12    Two Value look up in column 1  
  3  35  9    Four   Value look up in column 2  
  Two 6  12    8  Result  
 
syntax:  VLOOKUP2(lookup_value1,lookup_value2,table_array,col_index_num)

 

Andy's "Byg Software" site has a lot of zipped files.  You can get a free unzipper from Alladin Software at their StuffIt Expander™ site, click on the proper  FREE  button for your system.

To use simply drag a zipped file to the StuffIt Expander™, and the unzipped files will be placed in the same folder as the zipped file.

Please send your comments concerning this web page to: David McRitchie send email comments

Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved