Hello all

Having difficulties using application.vlookup in a script and hoped that someone on her could help.

A simplified version of my problem is as follows….

Worksheet1

Item1 Qty1

A1 2

A2 4

A3 1

A4 5

B1 1

B2 1

B2 3

C1 3

C2 8

C3 1…..

Worksheet2

Item2 Lookup Qty2

A1 A1/R 1

C2 C2/R 2

F1 F1/R 2…..

I need to perform a lookup from ‘Item1’ against ‘Item2’ and return the value‘Lookup’ AND the associated value ‘Qty1’ from Worksheet1 needs to be divided against ‘Qty2’ in worksheet2. The results to be shown in a third worksheet, so for the above it would be..

Worksheet3

Lookup Qty3

A1/R 2

C2/R 4….

Thanks for your time reading – if this doesn’t make sense please let me know

Bert