B

#### bojan0810

I need formula for this.

example...

A B C D

100 1 180

200 2 120

300 3 200

400 4 455

500 5 499

This is just an example, numbers in my sheets are different in column A not like that 100,200 etc, same as column b. And my data is on other column but that isnt important, I can change formula as I needed.

I tried with nested IFs but max of nested IFs is 64 so I cant use that.

Anyway what I need is this

Prob. a Vlookup formula but not sure. Anyway.

if on column C is 180, column D should be 2. If it is 120 then 2.

So it D column looks like this

D

2

2

3

5

5

Something like Vlookup to find that number from list. I have list of 10000 rows, thats why I need that. With ifs I can only do 64 rows.

Thanks in advance