LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
njuneardave
 
Posts: n/a
Default using VLOOKUP across two separate worksheets

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP to pick information from two worksheets mikeclimb Excel Worksheet Functions 1 March 13th 06 07:15 PM
Formula for adding totals from separate worksheets TRM Excel Discussion (Misc queries) 1 October 12th 05 05:35 PM
slight variation when working with separate worksheets Mr. Snrub Excel Discussion (Misc queries) 2 May 19th 05 01:24 PM
vlookup worksheet(s) jiwolf Excel Discussion (Misc queries) 1 April 12th 05 05:59 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"