copying trade values

[cj21]

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

 

[Guest]

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(A13,A$2:B$8,2,FALSE))

Make sure you use the "$" for the row in the datalist (here: 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