vlookup in different sheets

[NaomiF]

Hi all,

I was trying to find out how to search for duplicate entries with Vlookup in different sheets?

Thanks!

 

[Trustee]

Hi there,

Using the + Symbol in Excel

Start by selecting the target cell (in our case B1 of Sheet 2) and typing in the + symbol.

Next, right-click on the Sheet 1 label button to go back to your data. Select cell A1 and then pressEnter.

Your data will be automatically copied into cell B1.

If you performed the operation correctly, then upon selecting cell A1, you should have the following formula displayed in the formula bar: +Sheet1!A1.

Using the +Sheet(X)!((XY) Formula


The second method will make use of the +Sheet(X)!(XY) formula.

Select the cell in which you would like to swap the data and type +Sheet(X)!(XY) into the formula bar.

Using the conditions above, the formula+Sheet2!B21 will copy data from cell B21 of Sheet 2.

 

[L. Howard]

Vlookup will only find the first occurrence of the lookup value. Depending on what you want for results if dupes are present, you may want something like this.

=IF(COUNTIF(Sheet1!D2:L2,"q")>1,"yes","No")

Where the formula in on another sheet and the range D2:L2 is on Sheet1. Looks for the letter "q" and if more than one "q" then Yes, else No.

Howard