Lookup a value in a range & find the cell in another range for further usage

fortune

New member
Joined
Sep 26, 2014
Messages
7
Reaction score
0
Points
0
Location
MUMBAI
Excel Version(s)
2007
A6:L6 generates either 1 or 0 with a rule that ONLY 1 of the cell in the range (A6:L6) would be equal to 1.
A2:L2 also generates values.
I want to use the corresponding cell in the range A2:L2 for 1 generated in the A6:L6 for comparison with N2.
N2 also generates a value.
Output required: O2=If N2>=(cell from the range A2:L2) than 1000 else 2000.

How to accomplish.
Thanks
Sheet1


ABCDEFGHIJKLMNO
1Compare withResult
22004502501501752004001002005005551852002000
3
4
5
6001000000000
 
Sir I need help & it is urgent please.
 
Sorry, I hate to lose time at answers others might already be working on
 
Back
Top