Comparing columns & returning values

[nickkoehler]

Im going crazy trying to figure this out, help please!

I have data that looks like this:

_A__|_B__|_C__|_D__
123…………….234….$12
234 …………..236….$56
236 …………..123….$11
654 …………..764….$87
001 …………..654….$98
002…………………………..
764 …$87………………….
670…………………………..

Columns A & C are sku's. Column D is the $ value for sku's in column C. I need to compare column A & C, if there is a match, then I need the $ amount of that sku to populate column B, in the same row as the matching sku in column A. (sku 764 in column A has the value I'm looking for in column B)

 

[ace19852]

This is a simple matter of using VLOOKUP and I added ISNA to avoid seeing those pesty #N/A results when it doesn't match

Put this in B1 and copy down

=IF(ISNA(VLOOKUP(A1,$C$1:$D$5,2,0)),"",VLOOKUP(A1,$C$1:$D$5,2,0))

Just change the cell format to Currency US dollar and away ya go

and of course make sure column A and C is in the same format I used text for both !

Cheers