Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Return a value either from a two-row or two-column range

I am trying to value from two separate cells, but cannot figure it out. It
is similar to the "VLOOKUP" function, but that seems to only work for one
cell.

When I enter a description in "C4" and a thickness in "D5", I want to use
both of these information to to extract one number from another workbook.

Any Ideas?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default Return a value either from a two-row or two-column range

You can concatenate the first argument in the VLOOKUP formula like
this:
=VLOOKUP(C4&D5,your range, column, range_lookup) but it's CRITICAL that
the concatenation matches the items in the lookup range (because that's
how VLOOKUP works). For instance if your description is "two by four
board" and thickness is "1.5 in" and you concatenate those, the result
is "two by four board1.5 in". This will NOT match if the lookup range
value "two by four board 1.5 in" because there are two spaces between
"board" and "1.5". You may need to modify that concatenated value so
it can match the lookup range.

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
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
How to return a single value for a range of numbers Tami Excel Worksheet Functions 3 January 13th 06 02:34 AM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM


All times are GMT +1. The time now is 08:05 PM.

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

About Us

"It's about Microsoft Excel"