into string value into range based on lookup in another workbook

[knifelong]

hi I have a spreadsheet which might have variable headings as below

ID date 2 3 5 8 9


I would like to insert a description in the cell below the numerical value in the heading. The description is derived from a lookup in another workbook or worksheet. there is an example of this below.


1 descriptionA
2 descriptionB
3 descriptionC
4 descriptionD
5 descriptionE
6 descriptionF
7 descriptionG
8 descriptionH
9 descriptionI
10 descriptionJ


so the final result would look like this.


ID date 2 3 5 8 9
descritionB descritionC descritionE descritionH descritionI

I think it will be necessary to do this in VBA but I'm not sure where to start. Any help would be appreciated.

thanks

[mikerickson]

A formula like =VLOOKUP(C1, OtherSheet!$A$1:$B$10, 2, FALSE) should work

[knifelong]

thanks, yes this works