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

  • Thread starter Thread starter chad.levine
  • Start date Start date
C

chad.levine

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
Click to expand...

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?
 
=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?
Click to expand...

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
 
Back
Top