Copying information from earlier entries

[Zaqee]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]SAM[/TD]
[TD]$1500[/TD]
[TD]0.3%[/TD]
[TD]SMALL[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]TERRY[/TD]
[TD]$400[/TD]
[TD]1.3%[/TD]
[TD]MEDIUM[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]JONES[/TD]
[TD]$1300[/TD]
[TD]4.5%[/TD]
[TD]SMALL[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]ERIK[/TD]
[TD]$200[/TD]
[TD]2.2%[/TD]
[TD]MICRO[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]SAM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I'm trying to make a formula that would copy information from earlier entries if they exists.

So in this case, as soon as I've typed in SAM in A5, cell B1 would be copied to B5 (and so on).

I assume this could be done by LOOKUP function but I haven't been able to make it work.

Thanks,
Zack

 

[Finalfight40]

Try this:

Column B:

=VLOOKUP(A5, $A$1:D4, 2, 0)

Column C:

=VLOOKUP(A5, $A$1:D4, 3, 0)

Column D:

=VLOOKUP(A5, $A$1:D4, 4, 0)

If the entry has appeared previously, the data will auto populate.

 

[Zaqee]

Try this:

Column B:

=VLOOKUP(A5, $A$1:D4, 2, 0)

Column C:

=VLOOKUP(A5, $A$1:D4, 3, 0)

Column D:

=VLOOKUP(A5, $A$1:D4, 4, 0)

If the entry has appeared previously, the data will auto populate.

This returns an error, I think it's because VLOOKUP can't look to it's left.

Thank anyway.
T

 

[Finalfight40]

It should work for Sam but return N/A when duplicating down the column if the name has not appeared previously which means you would need to populate.

If you want to get rid of this you could wrap an =ifna(formula, " ") around it.

For example:

=IFNA(VLOOKUP(A5, $A$1:D4, 2, 0), " ")