Also, in addition to the code that you wrote:

=IF(ISNA(VLOOKUP(Data!H1,Types!$A$1:$A$9000,1,FALS E)),"",VLOOKUP(Data!H1,Types!$A$1:$A$9000,1,FALSE) )

What if there are values that I know are in Sheet 1 but not in Sheet 2 that
I want to exclude from the search. suppose, for example, Sheet 1 had like
"Balloons" in it 2000 times, but Sheet2 never had balloons (and i know this),
so I want to exclude balloons from my search. How would i do that? There
are three values that I want to leave out from the search: balloons,
confetti, and streamers. How do I exclude those three from that original
search code that you posted?

Thanks!

"njuneardave" wrote:

Hi,

Here is a description of my problem:


I have a project that contains two very large worksheets that are possibly
different sizes (depending on results of a program. approximately 3000-8000
lines). The first sheet has a value in column H, and I need to verify that
the variable in column 8 of the first sheet exists in column A of the second
sheet. If it exists, I want to populate a 3rd sheet with that value. If it
does not exist, I want to populate the 3rd sheet with a blank in that value's
spot. So, the 3rd sheet will be the same size as the 1st sheet (it will
either have the value that was found or a blank spot).


thanks for your help!