LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
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
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 06:57 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"