View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
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.