Thread: Macro help: VLOOKUP with conditions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
uberathlete uberathlete is offline
external usenet poster
  
Posts: 1
Default Macro help: VLOOKUP with conditions

Hi all. Say I have a sheet (sheet 1) that has this data:

Group ID Number
LMF1_bla AAAA 11111
LMF1_blu BBBB 33456
LMF2_gh KKKK 45456
LMF2_bla AAAA 22222


And then I have another sheet (sheet 2) with this data:

ID Number
AAAA


I basically want to VLOOKUP the Number for AAAA but only if it is part
of a Group that contains LMF1 in sheet 1. Can someone help me make a
macro for this task? Any help would be greatly appreciated.


--
uberathlete
------------------------------------------------------------------------
uberathlete's Profile: http://www.excelforum.com/member.php...o&userid=28388
View this thread: http://www.excelforum.com/showthread...hreadid=479763

Reply With QuoteReply With Quote