Live Chat & Podcast begin around 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Archive: Business Applications
Tag Cloud
access acer asus bios bsod computer crash drive driver drivers error ethernet excel freeze games gaming graphics hard drive hardware hdmi internet laptop malware memory monitor motherboard netgear network printer problem ram random registry router slow software sound trojan usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications > Archive: Business Applications >
Solved: Excel 2003- Matching text to a number.

Reply  
Thread Tools
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
09-Oct-2008, 04:39 PM #61
line by line...click on Go Advanced. Below this box for entering the message you should see a group of additional options.
Do you?
Tonservices's Avatar
Member with 41 posts.
 
Join Date: Sep 2008
09-Oct-2008, 04:51 PM #62
Yes, I see a group for additional options.
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
09-Oct-2008, 04:58 PM #63
Okay, do you see, in the second box of that group, a button that says Manage attachments?
If you do, click on it.
Tonservices's Avatar
Member with 41 posts.
 
Join Date: Sep 2008
09-Oct-2008, 04:58 PM #64
I am a big idiot. - Blonde moment!!!!
I am a big idiot. My problem is - I'm trying to run this program with Lotus. If I will use internet explore I hope my problems are fixed. I will wait and see. Thanks.
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
09-Oct-2008, 04:59 PM #65
Oh, definitely! Yes, the page is designed for HTML browsers.
Tonservices's Avatar
Member with 41 posts.
 
Join Date: Sep 2008
09-Oct-2008, 05:02 PM #66
Excel 2003- Matching numbers and inserting numbers.
I have finally attached this file. Take a look and give me some advice (Formula). Thanks a million
Attached Files
File Type: xls Tech help!!!!.xls (39.0 KB, 116 views)
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
09-Oct-2008, 05:18 PM #67
Ok, which item will you have on Sheet 1? The Given number?
Tonservices's Avatar
Member with 41 posts.
 
Join Date: Sep 2008
09-Oct-2008, 05:28 PM #68
Which item will you have on Sheet 1? I will be inputing information into sheet 1. I want sheet1 to match sheet 2 and return number and number date into sheet 1. I have an example on sheet 1 row 2.
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
09-Oct-2008, 05:38 PM #69
That's what I thought, but you have at the bottom of column B on Sheet1, "Match with Sheet 2 column B," but you also have the same thing, essentially, on column C and column G. Since the numbers in column B are unique, you only need the one item to match up with the data from sheet 2 - so you would not have to enter the data into columns C or G, either.
__________________
Iowa? I could have sworn this was heaven.
Well, I think I can answer this question most successfully in mime.
My theme song... | Affero - rate me!
Tonservices's Avatar
Member with 41 posts.
 
Join Date: Sep 2008
09-Oct-2008, 05:49 PM #70
Is it possible to match collumns (B,C,and G) in sheet 1 with Sheet 2?
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
09-Oct-2008, 06:00 PM #71
Matching things is easy - but you have to be clear what you are matching...it sounded earlier like y ou wanted to match "Given Number" on sheet2 with "Given Number" on sheet2 and "return number and number date into sheet 1" (date is not unique and the Total need not be so, so that makes sense.)
Are you now asking to pull all the data over? Just cut and paste.
If you want a match made conditional on all 3 of those values being the same, please make that clear.
__________________
Iowa? I could have sworn this was heaven.
Well, I think I can answer this question most successfully in mime.
My theme song... | Affero - rate me!
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
09-Oct-2008, 06:05 PM #72
For instance, this will return the "Number" value for column J
=IF(ISNA(INDEX(Sheet2!B:I,MATCH(B2,Sheet2!B:B,0),7)),"MISSING",INDEX(Sheet2 !B:I,MATCH(B2,Sheet2!B:B,0),7))
and it is just based on the value in "Given Number"
Tonservices's Avatar
Member with 41 posts.
 
Join Date: Sep 2008
09-Oct-2008, 06:10 PM #73
I want conditional on all 3. When all three are true insert sheet 2 column G & H. Thanks
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
09-Oct-2008, 06:34 PM #74
Well, the easiest way is to combine the data and match it. For instance, in Sheet2 in Column A, I wrote
=(B2&D2&G2)
then on Sheet1 in Column A I wrote
=(B2&C2&G2)
Then in Column J of Sheet1 I wrote
=IF(ISNA(INDEX(Sheet2!A:I,MATCH(A2,Sheet2!A:A,0),8)),"MISSING",INDEX(Sheet2 !A:I,MATCH(A2,Sheet2!A:A,0),8))
What this does is compare the combined data in Sheet2 A2 with the combined data in Sheet1 A2.
For the other data, you would use the same formula but change the column number (the "8" in the above case) to a "9" for the Number Date and a "7" for the Total.
__________________
Iowa? I could have sworn this was heaven.
Well, I think I can answer this question most successfully in mime.
My theme song... | Affero - rate me!
Tonservices's Avatar
Member with 41 posts.
 
Join Date: Sep 2008
09-Oct-2008, 07:05 PM #75
I have things in column A, D, E, F, H, & I of sheet 1. Can I move it to column L of sheet one? and Column L of sheet 2?
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 04:01 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.