|
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. |
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 |
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. |
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. |
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. |
| All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com