DanielBellfield
New Member
- Joined
- Mar 16, 2012
- Messages
- 36
I have a spreadsheet that I want to look up a certain row that is determined by a match formula in column 'A' but the information/price is in column 'C' any ideas of how i can get it to display the value to the right in 'H'?
A................B............C...........D...........E..........F...........G...........H
<tbody>
</tbody>
A................B............C...........D...........E..........F...........G...........H
Code | Price | ||||||
1001 | 15.48 | ||||||
1002 | 24.48 | Row | Price | ||||
1003 | 87.68 | 36 | |||||
1011 | 33 | ||||||
1013 | 43.4 | ||||||
1015 | 105.68 | ||||||
1020 | 35.08 | ||||||
1021 | 63.76 | ||||||
1022 | 290 | ||||||
1023 | 290 | ||||||
1210 | 7.7 | ||||||
1211 | 8.16 | ||||||
1212 | 8.5 |
<tbody>
</tbody>