Add Range to Array find Array value and Paste back to Range

Hi,

I am trying to work out (still learning Arrays) how to add a range to an Array then with each value in the Array find that value in
another sheet and add that value to the array and finally paste results back to worksheet.

What I have so far is adding range to Array and finding each array value..

Please Login or Register  to view this content.

I am still unsure how to add found value to the array and paste back onto sheet at a offset of 7 cells

Thanks

If the first value from C7 is found on the LAB83 sheet in cell B25, what exactly is supposed to happen? LAB83-C25 is pasted to activesheet-J7?

Ok, can't visualize that. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to automate.

Hi jindon,

Code did not return expected value
After dissecting I added some small changes and got result I needed

Please Login or Register  to view this content.

Is it now possible after examining my goal to place desired result in same cell as being divided by
and place in brackets.

Example 1st number to search is 102079 and value to divide is 7000 (column F)
result is 93.2

Objective = 7000(93.2) in same cell as 7000 (From included workbook earlier post)

Thanks
Lionel

I understand the fun with VBA, but doesn't this basic formula do what you described in your sample workbook instructions?

N8: =IF(C8="", "", F8 / VLOOKUP(C8, LAB!$B:$H, 7, 0))
...copied down.

Ok, good luck, then. If I were faced with this problem and "had to do it with VBA", I would use VBA to insert that formula and copy it down.