I made some changes thanks to your suggestion in your vlookup formula. I got
it to work with the index,match. Thank you!!
From: Nadine S
To: excel-macros@googlegroups.com
Sent: Mon, July 5, 2010 10:01:20 AM
Subject: Re: $$Excel-Macros$$ Need index match
Fabio Lemos
To: excel-macros@googlegroups.com
Sent: Sun, July 4, 2010 6:25:26 AM
Subject: Re: $$Excel-Macros$$ Need index match
Nadine,
Just type into Sheet1 Cell AQ2 the following:
=VLOOKUP(TEXT(D2;"@");Sheet2!$D:$O;12;0)
regards
2010/7/2 Nadine S
Attached is a workbook with 2 worksh
Nadine,
Just type into Sheet1 Cell AQ2 the following:
=VLOOKUP(TEXT(D2;"@");Sheet2!$D:$O;12;0)
regards
2010/7/2 Nadine S
> Attached is a workbook with 2 worksheets: Sheet 1 and Sheet 2
>
> Sheet 1 Col D is how the informatio nis received and it cannot be changed.
>
> Sheet 1 Col AQ is where I
