Formula or Macro to insert Data in Cell when having more than 7 Functions

[pwk]

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 (I’m fairly new) or a nested function to get
the results I need in B2:B12.

 

[Dave Peterson]

This looks like a natural fit for =vlookup().

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

 

[pwk]

Thanks for the lesson, I am Grateful.

Try this in B1 of Sheet2, and copy down.........

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

Vaya con Dios,
Chuck, CABGx3