Revised question from yesterday
Work Sheet 1 looks like this:
D3=4", F3=8", A11=8, C11=1977, F11=*, A12=8, C12=1984, D12=*; WHERE *=value to lookup from Work Sheet 2.
Work Sheet 2 looks like this and is sorted in ascending order by columns A & B:
A9=8, B9=1977, C9=8", D9=32
A10=8, B10=1984, C10=4", D10=263
The desire is to populate Work Sheet 1 with F11=32 and D12=263.
I am assuming I will have to use nested IF, LOOKUP functions, but have been unable to get the right combinations, error free.
Any help is greatly appreciated
Randy
This message was edited by rsw8679 on 2002-03-26 09:32
Work Sheet 1 looks like this:
D3=4", F3=8", A11=8, C11=1977, F11=*, A12=8, C12=1984, D12=*; WHERE *=value to lookup from Work Sheet 2.
Work Sheet 2 looks like this and is sorted in ascending order by columns A & B:
A9=8, B9=1977, C9=8", D9=32
A10=8, B10=1984, C10=4", D10=263
The desire is to populate Work Sheet 1 with F11=32 and D12=263.
I am assuming I will have to use nested IF, LOOKUP functions, but have been unable to get the right combinations, error free.
Any help is greatly appreciated
Randy
This message was edited by rsw8679 on 2002-03-26 09:32