I am using excel 2003 and am trying to return a number associated with
a column by comparing two columns.

Specifically, in the screenshot linked below, I am trying to populate
column D with the number in column F where column E matches column A.
Essentially, I want column D to contain the numbers in column H (which
I typed as reference only to help you help me!).

http://www.series11.net/files/ExcelExample.JPG

Thanks in advnace!!

>I am using excel 2003 and am trying to return a number associated with
> a column by comparing two columns.
>
> Specifically, in the screenshot linked below, I am trying to populate
> column D with the number in column F where column E matches column A.
> Essentially, I want column D to contain the numbers in column H (which
> I typed as reference only to help you help me!).
>
> http://www.series11.net/files/ExcelExample.JPG

Sorry, but I am confused. First off, you say you want to put the appropriate
values from column F in column D, but then go on to say that "essentially"
you want column D to contain numbers from column H. Can you clarify that
seemingly conflicting requirement for us? Also, I am unclear if you want the
match between column A and E to be on the same row or not. That is, for the
first 3 rows, column A's value matches column E's value (assuming you are
looking for a numeric match and not a textual match); but, afterward, the
values in A and E no longer match, row-for-row. Or, using row 6 as an
example, did you want the match to take place from E6 to A9 and, if so,
whose F or H value did you want, row 6's or row 9's?

Rick

=VLOOKUP(TEXT(E1,"0000"),$A$1:$F$100,6,0)

in D1, then copy down

I noticed some inconsistency, shouldn't 5 return 9 and 6 return 126?


--
Regards,

Peo Sjoblom



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am using excel 2003 and am trying to return a number associated with
> a column by comparing two columns.
>
> Specifically, in the screenshot linked below, I am trying to populate
> column D with the number in column F where column E matches column A.
> Essentially, I want column D to contain the numbers in column H (which
> I typed as reference only to help you help me!).
>
> http://www.series11.net/files/ExcelExample.JPG
>
> Thanks in advnace!!
>

> =VLOOKUP(TEXT(E1,"0000"),$A$1:$F$100,6,0)
>
> in D1, then copy down
>
> I noticed some inconsistency, shouldn't 5 return 9 and 6 return 126?

Based on the values shown in column H (which I now presume is what he wants
in column D), I think he is looking for this formula in D1...

=IF(ISNA(VLOOKUP(--A1,$E$1:$F$100,2,0)),"",VLOOKUP(--A1,$E$1:$F$100,2,0))

to be copied down.

Rick

Never mind... I think I see what you want now. See my response to Peo's post
for what I think you are asking for.

Rick


> >I am using excel 2003 and am trying to return a number associated with
>> a column by comparing two columns.
>>
>> Specifically, in the screenshot linked below, I am trying to populate
>> column D with the number in column F where column E matches column A.
>> Essentially, I want column D to contain the numbers in column H (which
>> I typed as reference only to help you help me!).
>>
>> http://www.series11.net/files/ExcelExample.JPG
>
> Sorry, but I am confused. First off, you say you want to put the
> appropriate values from column F in column D, but then go on to say that
> "essentially" you want column D to contain numbers from column H. Can you
> clarify that seemingly conflicting requirement for us? Also, I am unclear
> if you want the match between column A and E to be on the same row or not.
> That is, for the first 3 rows, column A's value matches column E's value
> (assuming you are looking for a numeric match and not a textual match);
> but, afterward, the values in A and E no longer match, row-for-row. Or,
> using row 6 as an example, did you want the match to take place from E6 to
> A9 and, if so, whose F or H value did you want, row 6's or row 9's?
>
> Rick