Collecting specific values from lists

  • Thread starter Thread starter res520
  • Start date Start date
R

res520

I’m still finding my feet with excel formulas and wondered if anyone a
bit more knowledgeable could offer some advice.

I’m trying to duplicate values from a list, and have the formula
=IF(EXACT(A2,I2),"",J2=B2)

Column A contains a part number and column I contains the result of a
VLOOKUP formula (copy of the part number). I have several other columns
where I need to extract/copy the contents of the lines where the
VLOOKUP has returned the part number – hence the IF EXACT part.

Columns B,C,D,E,F,G,H contain the part details and I am trying to copy,
and I,J,K….. is where I am trying to put them. I intend to duplicate
the formula changing the column identifier to get the info from and
into the various columns. It will then be copied down the list to
obtain the details of the relevant parts with blank lines where VLOOKUP
has returned NA.

With the current formula, the result is a blank instead of the data
(except where the vlookup has returned no result, where it is NA).

Can anyone see where I’m going wrong?
 
res520 said:
I’m trying to duplicate values from a list, and have the formula
=IF(EXACT(A2,I2),"",J2=B2)
Click to expand...
....

Looks like this should be the formula for cell J2. If so, it should be

=IF(ISNA($I2),"",IF(EXACT($A2,$I2),B2,""))

Copy J2 and paste into K2:P2, then fill J2:P2 down as far as needed.
 
try in cell J2

=IF(EXACT(A2,I2),"",B2)

This should give an empty string if A2=I2, otherwise display B2.

you problem is that excel functions return values not assign them. the
structure of the IF function is

IF (which function)
Logical Test (soemthing that equates to true or false)
Value_if_True (the value to display if Logical Test = True)
Value_if_False (the value to display .... = False)

Syntax "= IF(Logical_Test,Value_if_True, Value_if_False)"

steve
 
Back
Top