Seems simple but I cannot get it right!

Mike Curry

Expected CPM is generated using three columns from another sheet.

Column 1: OSM SKU

Column 2: OSM TF

Column 3: OSM CPM

I have tried IF/ IF AND / INDEX(Collect), all I get are errors. IF OSM SKU is xxxxx and OSM TF is 1111 it should return OSM CPM.

Any help would be appreciated!

Paul Newcome

Try this:

=INDEX(COLLECT({OSM CPM}, {OSM SKU}, @cell = "xxxxx", {OSM TF}, @cell = 1111), 1)

Paul Newcome

Try this:

=INDEX(COLLECT({OSM CPM}, {OSM SKU}, @cell = "xxxxx", {OSM TF}, @cell = 1111), 1)