lookup? retrieving entire row of data...

Ok, I have a workbook that has these columns:

category, line, status, carrier, billing, circuit, type, use, from, to, comments, budget, YTD spending, projected YE, variance, billing code (whew)

on another workbook in the same spreadsheet, I put a drop down with data validation to select the line (second column in the data on the other page).

upon selection, and clicking a button, I would like it to retreve the entire row that contains that line id...

for example... I select LI-43 from the drop down, click the button and below would see

ION (category), LI-43 (line), Active (Status), etc.

the page withall the data is the range starting at A4 thru P400 on a sheet named "master all lines".

I want the data to be displayed on a sheet named "Make Inactive" in row A15

Any help would be greatly appreciated!!!

Index/Match may be more beneficial in this situation. Assuming the validation list is in cell A5 of the "Make Inactive" sheet, copy this formula into cell A15, and copy over:

Please Login or Register  to view this content.

HTH

Jason

Hi, Terri. You need to copy that formula across the multiple columns, in order for it to return the full row. You are correct in that the formula will only return the data in column A. Copy cell A15 over through cell P15, and it should return the correct data.

HTH

Jason

ok, wow, that was really idiotic- why of course!

thanks so much!!!

works like a charm

t