Hello Friends,
I have a formula
=OFFSET(B2,MATCH(B2,$M$2:$M$1800,0)-1,-1)
where I need to assess whether the value in B2 exists in the range M2 to M1800.
If it does then take the value in A2.
All values are unique.
Thanks people for your assistance
Reagrds
Budge
I have a formula
=OFFSET(B2,MATCH(B2,$M$2:$M$1800,0)-1,-1)
where I need to assess whether the value in B2 exists in the range M2 to M1800.
If it does then take the value in A2.
All values are unique.
Thanks people for your assistance
Reagrds
Budge