Best way to link and lookup??

[johnshoe]

I have a worksheet (main) that contains 1500 rows that change each
month. I need to link 2-3 columns from "main" to 2 other worksheets
("planner", "workflow"). I also need "planner" & "workflow" to share
data.

I've been looking at the lookup, vlookup and hlookup functions to try
and figure this out, but I don't think this will work. As I understand
it, to use the lookup, the lookup source would have to be sorted in
ascending order. In my explanation above, neither planner nor workflow
would be sorted by the field I would be looking up, so I don't think
that the lookup functions would work. I think that I may need to go to
a database solution for this.

Any suggestions?

Thanks for your time
John

 

[Bernie Deitrick]

John,

With V/H LOOKUP, use the optional fourth parameter set to FALSE to
allow use with unsorted data.

From Help:

Range_lookup (the fourth parameter) is a logical value that specifies
whether you want VLOOKUP to find an exact match or an approximate
match. If TRUE or omitted, an approximate match is returned. In other
words, if an exact match is not found, the next largest value that is
less than lookup_value is returned. If FALSE, VLOOKUP will find an
exact match. If one is not found, the error value #N/A is returned

Match and Lookup both have similar parameters.

HTH,
Bernie
MS Excel MVP