Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP to pick information from two worksheets | Excel Worksheet Functions | |||
Formula for adding totals from separate worksheets | Excel Discussion (Misc queries) | |||
slight variation when working with separate worksheets | Excel Discussion (Misc queries) | |||
vlookup worksheet(s) | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) |