View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
swatsp0p[_38_] swatsp0p[_38_] is offline
external usenet poster
 
Posts: 1
Default Conditional VLOOKUP?


Use concatenation to create your lookup value. In your example, on
sheet 2, A1 contains the 'I' group name, so:

=VLOOKUP($A$1&"_"&A4,Sheet35!$A$2:$D$7,4,0) returns 4444 in C4

copy this down your range of group I entries.

similarly, A9 contains the group "II" name, so:

=VLOOKUP($A$9&"_"&A12,Sheet35!$A$2:$D$7,4,0) returns 55555 in C12

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=480574