lookup on range (A2 and D2:D30)

  • Thread starter Thread starter LFNFan
  • Start date Start date
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
 
sorry, ignore me. I figured it out with nested IFs. At least, it seems to
work anyhow.

=IF(ISERROR(VLOOKUP(N5,OFFSET('Trade Contract
TimeKeeper'!$B$2,0,0,COUNTA('Trade Contract
TimeKeeper'!$B$2:$B$18),1),1,FALSE)),IF(ISERROR(VLOOKUP(N5,'Trade Contract
TimeKeeper'!$A$2,1,FALSE)),NA(),R5),R5)
 
Back
Top