Thread: *-- VLOOKUP --*
View Single Post
  #2   Report Post  
cmart02
 
Posts: n/a
Default

Hi,

YOu can do this:

=INDEX(ColumnC,MATCH(M1&N1,ColumnA&ColumnB,0),1)

Now, press CTRL+SHIFT+ENTER and it is done.

I am recruting new members for my forum below... The site went live this
weekend and if you wish to take part, please, join me there so that we can
exchange some ideas. :-D

--
Regards
Robert
Find me at www.msofficegurus.com - be part of it!