Lookup value in a table and return muliple contiguous cells from a row

Hi. I hope someone can help me with this one. I know how to do a basic vlookup to return one value but don't know what to do in this situation.

I have a worksheet with many rows and columns. All the columns have headers. The lookup value is in column A. Based on this lookup value, I would like to return multiple contiguous cells from a row in a different worksheet (in the same workbook).

Thanks.

I believe you need the offset() function, it takes 5 arguements, the starting cell, the number of cells down and over that you would like to start the range at, then the height and width of the range. In this case, you would want to pass it the top left most cell, then based on your lookup move down some number of records and over 0. Returning back 1 column by X number of rows.

Hope this helps

Thirsty,

Take a look at the attachment and see if this gets you going or gives you any ideas.

Dean

Thanks psumvp and Dean England, I will try these out and let you know how it works for me.

Thanks again.

Thirsty