Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLookup??
first divide your third column (SeqRange) in two columns with the lower
boundary in column C and the upper boundary in column D After this use the following array formula (entered with CTRL+sHIFT+ENTER) on your second sheet: =MATCH('sheet1'!$B$1:$B$100,MATCH(1,(A1='sheet1'!$ A$1:$A$100)*(B2='she et1'!$C$1:$C$100)*(B2<='sheet1'!$D$1:$D$100),0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Question | Excel Discussion (Misc queries) | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
Vlookup with VBA | Excel Discussion (Misc queries) | |||
Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
Vlookup w/ VB | Excel Discussion (Misc queries) |