Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |