I need help with a formula

Master_L · #1 12-01-2016, 03:34 PM

Hi, i would like to know if have a formula or something who can do that.
Example:

A B C D

300 1 300 1
302 2 310 4
305 5 320 9
310 4 330 -
315 8 340 -
320 9 350 -

compare the value of A with C and if was the same, copy the value of B in D. I can do for same lines equals whit "IF" but when are different lines i can't.

Tanks and sorry about my english, but im desperate... i try some sites with examples and nothing works.

joeu2004 · #2 12-01-2016, 04:28 PM

In column D:

=IFERROR(VLOOKUP(C1,$A$1:$B$6,2,0),"-")

However, you cannot duplicate the format (black 2 v. red 4) unless you hand-code the Conditional Format.

Master_L · #3 12-01-2016, 06:06 PM

THANK YOU joeu2004!!!
its works with VLOOKUP (PROCV in Portuguese/BR) without IFERROR.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
help with a formula	srockwell25	Excel	4	08-22-2014 02:47 AM
Formula help	furface00	Excel	10	02-26-2012 05:34 AM
Formula Help - Look and if and that	Corca	Excel	2	02-05-2012 09:18 AM