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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chad.levine@gmail.com - 06 Jun 2007 18:05 GMT

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!!

Reply to this Message

Rick Rothstein (MVP - VB) - 06 Jun 2007 18:43 GMT

>I am using excel 2003 and am trying to return a number associated with
> a column by comparing two columns.
[quoted text clipped - 5 lines]
>
> 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

Reply to this Message

Rick Rothstein (MVP - VB) - 06 Jun 2007 19:36 GMT

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.
[quoted text clipped - 18 lines]
>
> Rick

Reply to this Message

Peo Sjoblom - 06 Jun 2007 18:47 GMT

=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?

Signature

Regards,

Peo Sjoblom

>I am using excel 2003 and am trying to return a number associated with
> a column by comparing two columns.
[quoted text clipped - 7 lines]
>
> Thanks in advnace!!

Reply to this Message

Rick Rothstein (MVP - VB) - 06 Jun 2007 19:35 GMT

> =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

Reply to this Message