Hi guys,
i used excel as a calculator but when i needed to make some effort to reach a solution for my problem it let me down, so i will write my problem
i have a record in my data base and i want excel to look if the record is in another range and apply some maths
so i wrote this formula
![]()
= if(vlookup("my record";"database";2;false)= one of the records in the other range; do math;nothing)
Bookmarks