vlookup using two table ranges

[Guest]

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

 

[N Harkawat]

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)