View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JR Winder JR Winder is offline
external usenet poster
 
Posts: 3
Default vlookup question

I'm trying to determine the price of item based on the size of that item.
Since I have 244 different sizes and prices, I was thinking the easiest way
to do this would be via vlookup. If there's an easier way, please don'
hesitate to tell me as I'm not at all familure with vlookup.

My spreadsheet looks like this: if you match the height of an item with it's
width, you get it's price. Example 12x12 = 42.00, 42x72=262.00,
78x24=211.00.

Can anyone help?

thanks

W I D T H
12 18 24 30 36 42 48 54 60 66 72 78 84 90 96
12 42 53 64 75 85 97 108 119 129 140 151 163 174 185 196
18 53 65 77 90 101 114 126 138 150 162 174 186 198 211 223
H 24 64 77 91 104 117 130 143 156 169 182 196 211 223 236 249
30 75 90 104 118 132 146 161 175 190 203 217 234 248 261 275
E 36 85 101 117 132 148 163 179 193 209 225 239 257 272 286 302
42 97 114 130 146 163 180 196 213 229 246 262 279 296 312 329
I 48 108 126 143 161 179 196 217 235 252 270 288 306 324 341 359
54 119 138 156 175 193 213 235 253 272 291 310 329 348 367 385
G 60 129 150 169 190 209 229 252 272 293 313 333 354 372 392 412
66 140 162 182 203 225 246 270 291 313 334 355 376 396 417 439
H 72 151 174 196 217 239 262 288 310 333 355 378 399 421 444 466
78 163 186 211 234 257 279 306 329 354 376 399 439 455 479 503
T 84 174 198 223 248 272 296 324 348 372 396 421 455 480 505 531
90 185 211 236 261 286 312 341 367 392 417 444 479 505 533 560
96 196 223 249 275 302 329 359 385 412 439 466 503 531 560 588
102 203 234 262 291 322 350 381 410 439 469 499 527 557 587 615
108 214 246 275 306 337 368 399 439 459 501 521 553 583 613 645