LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tjb
 
Posts: n/a
Default vlookup using two lookup values?

Is there a way to perform a vlookup with two lookup values? For instance,
I'd like to look up the value of A1 and B1 in a table with A1 and B1 values
included to return cell C2 from the table. Any ideas? I've had limited
succcess using concatenate and then using vlookup on that cell but i'd like
to not have to do the concatenate step.
 
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 doesn't work until i edit(but not change) the lookup cell Confused Excel Worksheet Functions 4 November 8th 05 09:15 AM
vlookup with 2 values NITESH G Excel Discussion (Misc queries) 2 November 8th 05 08:24 AM
How can I use the vlookup function to return a sum of the values? Chaandni Excel Discussion (Misc queries) 4 November 7th 05 03:05 PM
VLookup to sum cell values Zakynthos Excel Worksheet Functions 4 July 26th 05 12:05 PM
Multiple lookup value's rucker31 Excel Worksheet Functions 0 March 11th 05 11:17 PM


All times are GMT +1. The time now is 04:32 AM.

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

About Us

"It's about Microsoft Excel"