Hi Chris,
this is really simple to do. ;)
Assuming your data including the header for the columns start in A1 - here's
the formula you'll have to write besides the results list (which starts in
this case at A13):
=IF(ISNA(VLOOKUP(A13,A$2:B$8,2,FALSE)),0,VLOOKUP(A 13,A$2:B$8,2,FALSE))
Make sure you use the "$" for the row in the datalist (he A$2:B$8) - this
makes it easy for you to copy this formula to any row in your results list...
;)
Did this help you?
Best wishes,
Eric
"cj21" wrote:
I have a list of products, with corresponding trade values. e.g.
Product..Value
0123456 20
0132463 30
0148743 100
0245674 66
0237857 1000
0334626 3442
0435267 10234
I also have another list of products(which i call an "exceptions"
list), most of which are included above, however some are not. e.g
0123456
0148743
0237857
0912486
I want a formula that copies the trade value from list1 to list
2-sought of matching, so it would look like:
0123456 20
0148743 100
0237857 1000
0912486 0
Note the last product is not in list 1 so it gets a zero value.
Any formulas to do this.
Thanks for the help
Chris
--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=512244