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

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