View Single Post
  #1   Report Post  
mlou
 
Posts: n/a
Default vlookup using two table ranges

we need to look up data in two separate columns, A and C. we do not want to
include column B. how would we create our vlookup? we've tried several
options including
=vlookup(C2,[BILLINGS.XLS]SHADD'!$A$2:$A$1000+$C$2:$C$1000,2,FALSE). I guess
you could say we're not sure what we're doing! thanks