CODEWITHSUNDEEP
excelindexingexcel-formulamatch
marciokoko
marciokoko

Reputation: 4986

How to match up 2 columns with 2 other columns

In column A I have product id's and column B has the number of times the product in column A was quoted.

In column C I have the same product id's (but in different order) and column D has the number of times the product in column C was actually sold.

I want to match them up to add a final column in order to divide sales/quoted in order to get a value of efficiency in sales.

I believe it's an index/match/match but I'm not sure how to set it up.

Please help4 columns

Upvotes: 0

Views: 39

Answers (1)

teylyn
teylyn

Reputation: 35990

Try

=B3/vlookup(A3,C:D,2,false)

In words: take the value in B3 and divide it by the value from column D where column C has the same text as A3.

Upvotes: 2

Related Questions