Multiple Sheet Search - Matching Variables

**plasma33** · 05-06-2012, 06:31 AM

Hi Guys,

I want "Ion Annotation Result" sheet to be compared with "Result CAMERA Screened" sheet.
The Result I want in "Result" sheet is "Ion Annotation Result" sheet full and column B from "Result CAMERA Screened" sheet related to column B of "Ion Annotation Result" sheet in column C of "Result" sheet.

I have got the code. But its not working properly. Its only returning 38 hits. Actually it should return 114 hits. The output that I really want is in sheet name "###Actual Result That I Want###".

The code is as follows:

Please Login or Register  to view this content.

I am attaching the excel file. Please find the attachment.

Cheers
plasma33

**p24leclerc** · 05-08-2012, 09:02 PM

You can do it with a Vlookup formula.
You first have to sort the Camera sheet in ascending order based on column A.
Then add a column in Ion annotation sheet and place your Vlookup formula.
Copy this formula down the column and your all set.
Is it something you can live with?