So here is the story: I am trying to create a macro that will sort a row into the corresponding worksheet. I have an example of the data that I am trying to sort. For all cells of text with the value " 4828-010O", I want to place the number from the corresponding C Row. I have not had any luck with lookup functions.
I tried these excel formulas.
=LOOKUP(" 4828-024O",A1:A28,C1:C28)
=VLOOKUP(" 4828-024O",A1:A28,C1:C28)
Thanks for the help in advance,
Shawn
I tried these excel formulas.
=LOOKUP(" 4828-024O",A1:A28,C1:C28)
=VLOOKUP(" 4828-024O",A1:A28,C1:C28)
sorted.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 4880-020O | GOOD | 0.9283 | |||
2 | 4880-020I | GOOD | 0.629 | |||
3 | 4880-020W | GOOD | 0.1496 | |||
4 | 4880-020V | GOOD | 0.0119 | |||
5 | 4826-010O | GOOD | 0.7497 | |||
6 | 4826-010I | GOOD | 0.3243 | |||
7 | 4826-010W | GOOD | 0.2126 | |||
8 | 4826-010V | GOOD | 0.0182 | |||
9 | 4826-010O | GOOD | 0.7504 | |||
10 | 4826-010I | GOOD | 0.3221 | |||
11 | 4826-010W | GOOD | 0.2141 | |||
12 | 4826-010V | GOOD | 0.0177 | |||
13 | 4826-010O | GOOD | 0.7432 | |||
14 | 4826-010I | GOOD | 0.3175 | |||
15 | 4826-010W | GOOD | 0.2128 | |||
16 | 4826-010V | GOOD | 0.0123 | |||
17 | 4828-010O | GOOD | 0.7185 | |||
18 | 4828-010I | GOOD | 0.3181 | |||
19 | 4828-010W | GOOD | 0.2001 | |||
20 | 4828-010V | GOOD | 0.0285 | |||
21 | 4828-010O | GOOD | 0.7135 | |||
22 | 4828-010I | GOOD | 0.3139 | |||
23 | 4828-010W | GOOD | 0.1998 | |||
24 | 4828-010V | GOOD | 0.026 | |||
Sheet1 |
Thanks for the help in advance,
Shawn