lookup on range (A2 and D2:D30)

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
 
L

LFNFan

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top