Can't get vlookup or index/match to work in compare

[KDS14589]

I'm trying to compare in VBA two tables that are on the same sheet. The first table called "tableQ" and is in column "Q" (only one column wide) and starts in row 5 but ends in row 200. With no duplicates but many empty cells. Values are entered by way of a comboboxT userform that removes that value that is selected for the chosen cell in column "Q”, so that there are no duplicated values.

The other table is called "MasterT" and is in column "T" and starts in row 5 but ends at row 30. Values are entered and are use as a list for that comboboxT.

I'm comparing TableQ to the MasterT to see if a value in the MasterT has been used somewhere in the TableQ.

I've tried both vlookup and index/match but at this point I'm doing the old 'one step forward and two steps back'. HELP

My last attempt was (and of course it didn't work)(I would list all but there isn't space)

With ShGE03 'ShGE03 is the worksheet codename

Dim tableQ as range

Set tableQ = .Range("Q5:Q200")

Dim MasterT as Range

Set MasterT = .Range("T5:T30")

.Range("U5:U30").Formula = "=IFERROR(VLOOKUP(T5,tableQ,2,FALSE),""Not Used"")"

End With

 

[arun_eagertolearn]

Can you pls try in the last line

.Range("U5:U30").Formula = "=IFERROR(VLOOKUP(T5," & tableQ.Address & ",2,FALSE),""Not Used"")"

 

[Phuoc]

.Range("Q5:Q200") has only 1 column.

 

[arun_eagertolearn]

I feel still it should work

 

[Phuoc]

It works with: "=IFERROR(VLOOKUP(T5," & tableQ.Address & ",2,FALSE),""Not Used"")" ?

 

[Cubist]

Since tableQ is a single-column range then the column index should be 1 and not 2?

 

[KDS14589]

I solved this myself by modifying my code as such.................

with ShGE03
Dim k As Integer
For k = 5 To 30

.Cells(k, "U").Value = "=IF(ISERROR(MATCH(R[-2]C[-1], R5C17:R110C17, 0)), ""Not Used"", """" )"

Next k
END WITH

Now I have 2 other problems that I'll post in new threads
Thanks to everyone for the suggestions