View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

It would be better if you posted some example
the formula below is assuming that the data in cell C2 is a concatenate of
col A and Col c data (an in that order)
and the returned value is column B

=index(b1:b1000,match(c2,[BILLINGS.XLS]SHADD'!A1:a1000&[BILLINGS.XLS]SHADD'!C1:c1000,0))
Array entered (ctrl+shift+enter)





"mlou" wrote in message
...
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