Lester
11-02-2007, 03:24 AM
Hi
Still struggling with VBA, unfortunately.
[see attachment]
Anyway, I need to lookup data in column F ('Labour/Consultant') of worksheet 'Charge Rates Look-up' based on data in columns A, B and D of worksheet 6, then 'paste' it into empty column J of sheet 6.
I have tried the following function in cell J2, but it is clearly wrong, as the expected value does not appear in the cell:
VLOOKUP(--('Charge Rates Look-up'!$A$1:$A$87=Sheet6!A2), --('Charge Rates Look-up'!$B$1:$B$87=Sheet6!B2), --('Charge Rates Look-up'!$D$1:$D$87=Sheet6!D2),'Charge Rates Look-up'!$F$1:$F$87)
Please help.
Many thanks
Lester.
Still struggling with VBA, unfortunately.
[see attachment]
Anyway, I need to lookup data in column F ('Labour/Consultant') of worksheet 'Charge Rates Look-up' based on data in columns A, B and D of worksheet 6, then 'paste' it into empty column J of sheet 6.
I have tried the following function in cell J2, but it is clearly wrong, as the expected value does not appear in the cell:
VLOOKUP(--('Charge Rates Look-up'!$A$1:$A$87=Sheet6!A2), --('Charge Rates Look-up'!$B$1:$B$87=Sheet6!B2), --('Charge Rates Look-up'!$D$1:$D$87=Sheet6!D2),'Charge Rates Look-up'!$F$1:$F$87)
Please help.
Many thanks
Lester.