Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Search for a specific cell based on two criteria

Okay,
Heres the challenge, I am attempting to insert a value into a
specific cell based upon a search of two columns to find the matching
criteria. To give an example, I am inserting a number into the "C"
column cell next to the matching "A" and "B" fields.
So if I was looking to insert the "total sales" for a branch of a
company(C value). I would look first for the month(A value), then the
branch name(B value) then insert fhe value in the column next to those
values.
To give a practical Example the Seattle branch has "4000" in sales for
january. The values of Seattle and January are already in the sheet. I
just need to insert 4000 into the column next to that

A B C
1 January Dallas ----
2 January Seattle <value needs to be inserted here
3 Januray Omaha ----
4 January New York ----

To make things easier, I already have code written to get the user
input of month and branch. So assuming that you would have those two
values stored in string variables, what would be the best approach to
tackling this?
Thanks in advance for any help given,

Rob

Reply
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
cell refrence based on specific criteria Jenn Excel Discussion (Misc queries) 3 September 22nd 08 08:54 PM
SUMIF, with specific search criteria Bglib Excel Worksheet Functions 3 April 11th 07 09:56 PM
Transfer single cell information to specific cell based on user criteria RoVo Excel Programming 0 May 31st 06 04:20 PM
I am trying to color fill a cell based on specific criteria jglen Excel Discussion (Misc queries) 1 May 27th 05 05:30 PM
Excel XP VBA code to search all macro code in Excel module for specific search string criteria Frank Kabel Excel Programming 0 May 19th 04 08:11 PM


All times are GMT +1. The time now is 07:02 AM.

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

About Us

"It's about Microsoft Excel"