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
 

fortune

New member
Joined
Sep 26, 2014
Messages
7
Reaction score
0
Points
0
Location
MUMBAI
Excel Version(s)
2007
Sir I need help & it is urgent please.
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,779
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Sorry, I hate to lose time at answers others might already be working on
 
Top