Is there a way to have the column index number find it for you without having to count? If I have 50 columns and in the first Vlookup the column index is 10, in the second Vlookup the column index is 40.
Example:
<colgroup><col span="6"></colgroup><tbody>
</tbody>
Thank you for your support.
Elaine
Example:
1 | 2 | 3 | 4 | 5 | 6 |
Item No. | Product | Unit Price | Quantity In Stock | MSRP | Store # |
111 | Sony CD Player | $350.00 | 1002 | $495 | 1011 |
222 | Apple Ipod | $375.00 | 1478 | 603 | 1012 |
333 | Sony 20" Monitor | $650.00 | 4562 | 750 | 1013 |
444 | HP Printer | $250.00 | 1597 | 325 | 1014 |
555 | Nikon Digital Camera | $895.00 | 2456 | 1025 | 1015 |
<colgroup><col span="6"></colgroup><tbody>
</tbody>
Thank you for your support.
Elaine