Macro: Find - Match - Return Value

[PoorFrog]

Hi everyone,

Here is an extract of my database. In the "Score" sheet we have different columns from which I have to find specific words to match with those from "Data" sheet.
I would like to create a macro :
If there is more than 1 Instr in columns C, G, K and O then columns S, T, U and V are forced to "00" (knowing that in original database we have 100 instruments)
If in Score there is an empty cell then returns "00" in the desired column from S to V.
If in Score cell not is empty then find match in "Data" and return "Data" value in the desired column from S to V.
Score_Ref is a concatenate function.
Attached a Image of the tables.
Thanks for your help.
PF

 

[PoorFrog]

Hi everyone,

If it wasn't in vba I would write something like that:

Count = 0
nb_instr = 0
While Count<2
If(not(isEmpty(cell(row,3 + nb_instr x 4))):
Count+ =1
nb_instr+ = 1
If Count ==2
Instr_Ref = 0

Elif Count ==1
Instr_Ref = ....

Else
Error