Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a vb loop for vlookup
I need a VB loop which will looks at ID's in cells A2 to A400, check to
see if corresponing ID's exist in cells I2:I400. If so, pick up Column M and paste this back into Col G. If the ID does not exist then it should say something like "New". I have got this far (gleamed and amended from other Newsgroups postings) but I am unable to work out how to do the loop. Can somebody please help? Many thanks Tony Sub CheckTotals() With Worksheets("Totals") .Cells(2, 7) = Application.VLookup(.Cells(2, 1), .Range("I2:M400"), 5, False) End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a vlookup command in a for next loop in a macro in excel | Excel Discussion (Misc queries) | |||
VLOOKUP loop multiple times | Excel Worksheet Functions | |||
Need a vb loop for vlookup | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Find & Replace / Loop & Vlookup | Excel Programming |