Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 08:21 PM
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

  #2   Report Post  
Old May 18th 05, 08:43 PM
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP Function using Data Ranges. Cal Excel Worksheet Functions 6 April 16th 05 03:26 PM
Table Array in VLOOKUP Relies on Data Validation willydlish Excel Worksheet Functions 2 February 16th 05 03:20 AM
How to use a cell value as Table Array in VLOOKUP worksheet function willydlish Excel Discussion (Misc queries) 2 February 16th 05 02:47 AM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 10:43 AM
vlookup and named ranges chathag Excel Worksheet Functions 3 November 22nd 04 04:07 PM


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017