Thanks:  0
Likes:  0

1. 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 ]

2. Here's something ugly but effective:

On Sheet 2, insert a column D between C and old column D and populate it like this:
D8: = A8 & B8 & C8

Now, on Sheet 1, the cells on D and F would be:
F11=VLOOKUP(\$A11&\$C11&F\$4,Sheet2!\$C\$2:\$D\$999,2,False)
D12=VLOOKUP(\$A12&\$C12&D\$4,Sheet2!\$C\$2:\$D\$999,2,False)

HTH

_________________
"Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

[ This Message was edited by: Tim Francis-Wright on 2002-03-26 10:47 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•