Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Formula or Macro to insert Data in Cell when having more than 7 Functions
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pwk pwk is offline
external usenet poster
  
Posts: 9
Default Formula or Macro to insert Data in Cell when having more than 7 Functions
I have this workbook that contains this Sheet1
A B
1 013 MTR LTR POLY TYPD 4 X 9½
2 023 MTR CARD TYPD 4¼ X 6
3 101 STP CARD CLSD HAND 4¾ X 6½
4 103 STP LTR CLSD HAND 4 X 9½
5 104 STP LTR CLSD HAND 3 X 6½
6 109 STP FLT CLSD HAND 9 X 12
7 111 STP CARD HAND 4 X 6
8 112 MTR LTR POLY TYPD 4 X 9½
9 116 STP LTR OPEN TYPD 4 X 9½
10 120 MTR FLT POLY TYPD 9 X12
11 197 MTR LTR POLY TYPD 4 X 7
12 199 MTR LTR POLY TYPD 3 X 7½
13 206 STP LTR CLSD TYPD 4 X 9½
14 214 MTR LTR POLY TYPD 4½ X 7½
15 218 MTR LTR POLY TYPD 4½ X 9½
16 219 STP LTR CLSD TYPD 4 X 9½
17 315 MTR LTR OPEN TYPD 3 X 6½
18 398 STP LTR CLSD TYPD 3 X 8

I have this on Sheet2 or in another Workbook..

A B
1 218
2 199
3 116
4 104
5 109
6 116
7 120
8 214
9 101
10 214
11 199
12 315

I want B1 to say, MTR LTR POLY TYPD 4½ X 9½
I want B2 to say, MTR LTR POLY TYPD 3 X 7½

This the formula I have used to get B1; =IF(A1=218,'Sheet1'!$B$15)
How can I use a Macro (Im fairly new) or a nested function to get
the results I need in B2:B12.

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 35,218
Default Formula or Macro to insert Data in Cell when having more than 7Functions
This looks like a natural fit for =vlookup().

Debra Dalgleish explains it:
http://www.contextures.com/xlFunctions02.html

pwk wrote:

I have this workbook that contains this Sheet1
A B
1 013 MTR LTR POLY TYPD 4 X 9½
2 023 MTR CARD TYPD 4¼ X 6
3 101 STP CARD CLSD HAND 4¾ X 6½
4 103 STP LTR CLSD HAND 4 X 9½
5 104 STP LTR CLSD HAND 3 X 6½
6 109 STP FLT CLSD HAND 9 X 12
7 111 STP CARD HAND 4 X 6
8 112 MTR LTR POLY TYPD 4 X 9½
9 116 STP LTR OPEN TYPD 4 X 9½
10 120 MTR FLT POLY TYPD 9 X12
11 197 MTR LTR POLY TYPD 4 X 7
12 199 MTR LTR POLY TYPD 3 X 7½
13 206 STP LTR CLSD TYPD 4 X 9½
14 214 MTR LTR POLY TYPD 4½ X 7½
15 218 MTR LTR POLY TYPD 4½ X 9½
16 219 STP LTR CLSD TYPD 4 X 9½
17 315 MTR LTR OPEN TYPD 3 X 6½
18 398 STP LTR CLSD TYPD 3 X 8

I have this on Sheet2 or in another Workbook..

A B
1 218
2 199
3 116
4 104
5 109
6 116
7 120
8 214
9 101
10 214
11 199
12 315

I want B1 to say, MTR LTR POLY TYPD 4½ X 9½
I want B2 to say, MTR LTR POLY TYPD 3 X 7½

This the formula I have used to get B1; =IF(A1=218,'Sheet1'!$B$15)
How can I use a Macro (Im fairly new) or a nested function to get
the results I need in B2:B12.

--

Dave Peterson
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default Formula or Macro to insert Data in Cell when having more than 7 Fu
Try this in B1 of Sheet2, and copy down.........

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"pwk" wrote:

I have this workbook that contains this Sheet1
A B
1 013 MTR LTR POLY TYPD 4 X 9½
2 023 MTR CARD TYPD 4¼ X 6
3 101 STP CARD CLSD HAND 4¾ X 6½
4 103 STP LTR CLSD HAND 4 X 9½
5 104 STP LTR CLSD HAND 3 X 6½
6 109 STP FLT CLSD HAND 9 X 12
7 111 STP CARD HAND 4 X 6
8 112 MTR LTR POLY TYPD 4 X 9½
9 116 STP LTR OPEN TYPD 4 X 9½
10 120 MTR FLT POLY TYPD 9 X12
11 197 MTR LTR POLY TYPD 4 X 7
12 199 MTR LTR POLY TYPD 3 X 7½
13 206 STP LTR CLSD TYPD 4 X 9½
14 214 MTR LTR POLY TYPD 4½ X 7½
15 218 MTR LTR POLY TYPD 4½ X 9½
16 219 STP LTR CLSD TYPD 4 X 9½
17 315 MTR LTR OPEN TYPD 3 X 6½
18 398 STP LTR CLSD TYPD 3 X 8

I have this on Sheet2 or in another Workbook..

A B
1 218
2 199
3 116
4 104
5 109
6 116
7 120
8 214
9 101
10 214
11 199
12 315

I want B1 to say, MTR LTR POLY TYPD 4½ X 9½
I want B2 to say, MTR LTR POLY TYPD 3 X 7½

This the formula I have used to get B1; =IF(A1=218,'Sheet1'!$B$15)
How can I use a Macro (Im fairly new) or a nested function to get
the results I need in B2:B12.


Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pwk pwk is offline
external usenet poster
  
Posts: 9
Default Formula or Macro to insert Data in Cell when having more than 7 Fu
Thanks for the lesson, I am Grateful.
CLR wrote:
Try this in B1 of Sheet2, and copy down.........

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"pwk" wrote:

I have this workbook that contains this Sheet1
A B
1 013 MTR LTR POLY TYPD 4 X 9½
2 023 MTR CARD TYPD 4¼ X 6
3 101 STP CARD CLSD HAND 4¾ X 6½
4 103 STP LTR CLSD HAND 4 X 9½
5 104 STP LTR CLSD HAND 3 X 6½
6 109 STP FLT CLSD HAND 9 X 12
7 111 STP CARD HAND 4 X 6
8 112 MTR LTR POLY TYPD 4 X 9½
9 116 STP LTR OPEN TYPD 4 X 9½
10 120 MTR FLT POLY TYPD 9 X12
11 197 MTR LTR POLY TYPD 4 X 7
12 199 MTR LTR POLY TYPD 3 X 7½
13 206 STP LTR CLSD TYPD 4 X 9½
14 214 MTR LTR POLY TYPD 4½ X 7½
15 218 MTR LTR POLY TYPD 4½ X 9½
16 219 STP LTR CLSD TYPD 4 X 9½
17 315 MTR LTR OPEN TYPD 3 X 6½
18 398 STP LTR CLSD TYPD 3 X 8

I have this on Sheet2 or in another Workbook..

A B
1 218
2 199
3 116
4 104
5 109
6 116
7 120
8 214
9 101
10 214
11 199
12 315

I want B1 to say, MTR LTR POLY TYPD 4½ X 9½
I want B2 to say, MTR LTR POLY TYPD 3 X 7½

This the formula I have used to get B1; =IF(A1=218,'Sheet1'!$B$15)
How can I use a Macro (Im fairly new) or a nested function to get
the results I need in B2:B12.



Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default Formula or Macro to insert Data in Cell when having more than
Happy to be of help...........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3




"pwk" wrote:

Thanks for the lesson, I am Grateful.
CLR wrote:
Try this in B1 of Sheet2, and copy down.........

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"pwk" wrote:

I have this workbook that contains this Sheet1
A B
1 013 MTR LTR POLY TYPD 4 X 9½
2 023 MTR CARD TYPD 4¼ X 6
3 101 STP CARD CLSD HAND 4¾ X 6½
4 103 STP LTR CLSD HAND 4 X 9½
5 104 STP LTR CLSD HAND 3 X 6½
6 109 STP FLT CLSD HAND 9 X 12
7 111 STP CARD HAND 4 X 6
8 112 MTR LTR POLY TYPD 4 X 9½
9 116 STP LTR OPEN TYPD 4 X 9½
10 120 MTR FLT POLY TYPD 9 X12
11 197 MTR LTR POLY TYPD 4 X 7
12 199 MTR LTR POLY TYPD 3 X 7½
13 206 STP LTR CLSD TYPD 4 X 9½
14 214 MTR LTR POLY TYPD 4½ X 7½
15 218 MTR LTR POLY TYPD 4½ X 9½
16 219 STP LTR CLSD TYPD 4 X 9½
17 315 MTR LTR OPEN TYPD 3 X 6½
18 398 STP LTR CLSD TYPD 3 X 8

I have this on Sheet2 or in another Workbook..

A B
1 218
2 199
3 116
4 104
5 109
6 116
7 120
8 214
9 101
10 214
11 199
12 315

I want B1 to say, MTR LTR POLY TYPD 4½ X 9½
I want B2 to say, MTR LTR POLY TYPD 3 X 7½

This the formula I have used to get B1; =IF(A1=218,'Sheet1'!$B$15)
How can I use a Macro (Im fairly new) or a nested function to get
the results I need in B2:B12.




Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

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
insert date Larry Excel Worksheet Functions 28 July 15th 06 02:41 AM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM


All times are GMT +1. The time now is 03:05 PM.

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"

 

Contact Us ExcelBanter forum home Privacy Statement