PDA

View Full Version : into string value into range based on lookup in another workbook



knifelong
05-22-2013, 07:41 AM
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
05-22-2013, 07:47 AM
A formula like =VLOOKUP(C1, OtherSheet!$A$1:$B$10, 2, FALSE) should work

knifelong
05-22-2013, 08:32 AM
thanks, yes this works