Hi all, i have an issue with using the if formula in conjuction with an array.
In sheet 2 i have an array explaining what i need. So for code 1,2,5 attention is Y and for 3,4,6 is N.
I need a formula in sheet 1 column F which checks the code that is in column D and provides Y or N in column F, but only if the amount is above 1500.
Is that possible.
f1 = € 1500
f2 =if($C2>$F$1,VLookup($D2,Sheet2!$B$2:$D$7,3,0),"") and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Use this formula
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks