Hi all! I've got two sheets, sheet 1 and 2 (attached). Basically, I nee
the Number column in Sheet 2 to be filled up with Sheet 1 as th
reference for the needed data. The problem is that some entries i
Sheet 1 have the same ID but are from different Groups. For example
AAA Inc. has an ID of AAA but can be in either LMFI_AAA or LMFII_AAA
So, I basically need some sort of VLOOKUP that recognizes the Group o
something like that. Any help would be greatly appreciated.

http://www.excelforum.com/attachment...tid=3976&stc=1
http://www.excelforum.com/attachment...ntid=3977&stc=

+-------------------------------------------------------------------
|Filename: sheet2.JPG
|Download: http://www.excelforum.com/attachment.php?postid=3977
+-------------------------------------------------------------------

--
uberathlet
-----------------------------------------------------------------------
uberathlete's Profile: http://www.excelforum.com/member.php...fo&userid=2838
View this thread: http://www.excelforum.com/showthread.php?threadid=48057