Please help with Vlookup

[swiftpak]

Hi,

Please see attached my spreadsheet. I would like to know which items in 'Sheet 1' are also in 'Master' using VLOOKUP in the J column of 'Master'. Column C in both worksheets. Please help

Thanks in advance.

[etaf]

try using a countif()

in J2 on Master sheet put
=COUNTIF(Sheet1!$C$1:$C$250,Master!C2)
and then copy down the master sheet

you will get a count when the item appears
OR you could include and IF() to specify a response

Change the range
Sheet1!$C$1:$C$250

to suit how large your range on Sheet1 will become in the future

[swiftpak]

Thanks Wayne, your formula worked! Much appreciated!

[etaf]

you are welcome - thanks for the rep