Nirvana
asked on
vlookup/ range within a range
i have two columns where i have the numbers ranging from 1000 to 9000 (column D) and other column i have amount (Column E).
i need a message in a new column as "post" if the range is between 3000 to 8999 and the amount is negative
example if D2 is 3000 and E2 is -1200 i should have "post in cell F2
hope i am clear
i need a message in a new column as "post" if the range is between 3000 to 8999 and the amount is negative
example if D2 is 3000 and E2 is -1200 i should have "post in cell F2
hope i am clear
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:)
Well done... I really must learn to read the question.
Yes...
In cell [F2]:
=IF(AND(D2>=3000,D2<=8999,E2<0),"post", "")
Copy this to your clipboard, & copy down column [F] to the extent of your data in columns [D] & [E].
Please see the attached workbook.
Q-28708743.xls
Well done... I really must learn to read the question.
Yes...
In cell [F2]:
=IF(AND(D2>=3000,D2<=8999,E2<0),"post",
Copy this to your clipboard, & copy down column [F] to the extent of your data in columns [D] & [E].
Please see the attached workbook.
Q-28708743.xls
ASKER
Thanks a lot.. was the question really confusing..
:)
No... I was too busy creating a workbook as an example, & should have checked what I typed into the comment to you in the forty seconds before the second solution was posted.
Never mind.
No... I was too busy creating a workbook as an example, & should have checked what I typed into the comment to you in the forty seconds before the second solution was posted.
Never mind.
=IF(AND(D2>=1000,D2<=8999,
Copy this to your clipboard, & copy down column [F] to the extent of your data in columns [D] & [E].