L
LFNFan
Hi
I have this arrangement:
A B
1 From To
2 abc def
3 def ghi
4 ghi jkl
I want to lookup a value in a separate array against the values in cell A2
(the initial starting point) _and_ all the values in the 'To' array.
I have the vlookup for the 'To' array, but I'm stuck on how to add the A2
array in to the mix.
This is what I have for the 'To' array
=IF(ISERROR(VLOOKUP(N5,OFFSET('Trade Contract
TimeKeeper'!$B$2,0,0,COUNTA('Trade Contract
TimeKeeper'!$B$2:$B$18),1),1,FALSE)),NA(),R5)
Hope that makes sense.
Any help greatfully received
I have this arrangement:
A B
1 From To
2 abc def
3 def ghi
4 ghi jkl
I want to lookup a value in a separate array against the values in cell A2
(the initial starting point) _and_ all the values in the 'To' array.
I have the vlookup for the 'To' array, but I'm stuck on how to add the A2
array in to the mix.
This is what I have for the 'To' array
=IF(ISERROR(VLOOKUP(N5,OFFSET('Trade Contract
TimeKeeper'!$B$2,0,0,COUNTA('Trade Contract
TimeKeeper'!$B$2:$B$18),1),1,FALSE)),NA(),R5)
Hope that makes sense.
Any help greatfully received