Lookup Help

[abbyt1904]

Hi

Can anyone help?

I am trying to populate the second row with the Training Day Rate in the bottom part but cant seem to get it to work. I've tried hlookup but that is for the table array being horizontal, how do I do it for the source data being horizontal?

JLR Hyundai Hyundai JLR JLR £400 Hyundai £500 <tbody> </tbody> Thanks

<colgroup><col span="5"></colgroup><tbody>
</tbody>

 

[elmer007]

I may not be reading the question correctly, but I think that vlookup may be the thing to use here. I'm assuming that you have JLR, Hyundai, Hyundai, and JLR in cells A1, B1, C1, and D1; and that JLR, L400, Hyundai, and L500 are in cells A3, B3, A4, and B4.

In cell A2, put: =vlookup(A1,A3:B4,2,false)

Then copy this cell and paste it across row two (into cells B2:D2).


Let me know if this doesn't work or if you have any questions.