Excelworld
New Member
- Joined
- Nov 10, 2011
- Messages
- 33
Hi All,
I need to do a Vlookup on a persons name in sheet1 to find that persons name in sheet2 and put a "Yes" in the correct cell of column 26 when it finds the name
so far I have:
#Application.WorksheetFunction.VLOOKUP(B3,Sheet2.Range("C3:AB1000"), 26, FALSE)# - 'so the cell that it finds will be empty but I want it to now populate this cell with the word "Yes"
Any help would be great
Thanks in advance
EW
I need to do a Vlookup on a persons name in sheet1 to find that persons name in sheet2 and put a "Yes" in the correct cell of column 26 when it finds the name
so far I have:
#Application.WorksheetFunction.VLOOKUP(B3,Sheet2.Range("C3:AB1000"), 26, FALSE)# - 'so the cell that it finds will be empty but I want it to now populate this cell with the word "Yes"
Any help would be great
Thanks in advance
EW