LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteveC
 
Posts: n/a
Default Skipping a cell and moving on to the next, with no blanks in betwe

Three worksheets

Worksheet 1 has values in A7:A2000
Worksheet 2 has values in B8:B18
Worksheet 3 is where I want a formula to do the following:

Worksheet3 Cell A1, for example:
Formula: If worksheet1!A10 does not equal worksheet2!b8:18, then return the
value in worksheet1!A10

Then if I drag down the formula to worksheet3!A2 , and if Worksheet1!A11
DOES equal any values in worksheet2!b8:b18, do not leave blank, but instead
fill return a value in worksheet1!A12 but only if worksheet1!A12 does not
equal any criteria in worksheet2!b8:b18, etc...

so I can pull down the formula a few hundred rows, omitting those values
that are attached to some specififed criteria as listed in worksheet 2.

Hope this makes sense... I appreciate your help... thanks...
 
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
Slow Moving From Cell to Cell rlaf Excel Discussion (Misc queries) 2 April 21st 06 07:13 PM
HOW TO KEEP TEXT FROM MOVING OUT OF A CELL? Briguyy Excel Discussion (Misc queries) 2 February 23rd 06 09:04 PM
moving from cell to cell Stumped Excel Discussion (Misc queries) 1 November 28th 05 08:50 PM
Moving from cell to cell Chuck Davis Excel Discussion (Misc queries) 3 August 9th 05 12:19 AM
Arrow keys move screen instead of moving from cell to cell. JaJay777 Setting up and Configuration of Excel 1 January 17th 05 06:48 PM


All times are GMT +1. The time now is 06:48 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"