Lookup a value in a range & find the cell in another range for further usage
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
A B C D E F G H I J K L M N O 1 Compare with Result 2 200 450 250 150 175 200 400 100 200 500 555 185 200 2000 3 4 5 6 0 0 1 0 0 0 0 0 0 0 0 0
Sir I need help & it is urgent please.
Sorry, I hate to lose time at answers others might already be working on
Here, here!Originally Posted by Pecoflyer
Well said. Ive wasted loads of work on these !
Reply With Quote
Bookmarks