Match data

[alanyaber]

Hi

I have a list that looks like this

Section....From......To
S1...........0..........10
S1..........10..........20
S2..........100........110
S2..........110.......120
etc.

My other list looks like this:

Section....From......To......Value
S1...........0..........10........99
S2..........100........110......145

I'd like to have the following output:

Section....From......To.........Value
S1...........0..........10...........99
S1..........10..........20..........NA
S2..........100........110.........145
S2..........110.......120...........NA
etc.

VLOOKUP doesn't work because I have more that one variable. I think it should be Match/Index but I don't know how to use this command

Thanks

[NBVC]

Assuming your lookup table is in W2:Z10 and your data starts in A2:C2, put this formula in D2:

Please Login or Register  to view this content.

adjust ranges and cell refs to suit and this formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER. You'll see {} brackets appear around the formula