Richard,
I have one spread sheet with 503 school district names and test scores (I pulled this from the Department of Ed's website). I only needed information from 110 schools - I pulled those schools into another spreadsheet for my use. I promptly deleted two columns I thought I wouldn't need. Murphy's law, I now realize I want those columns back. Is there an easy way to retrieve those two columns from the original spreadsheet using a formula?  I would prefer not to have to cut and paste.  Thanks for your help, Cristine

---

Answer from Richard Rost:

You could use VLOOKUP to pull that information into your 2nd sheet (assuming you still have the original). Then you could copy and paste-special the DATA into a third sheet. This would prevent you from having to select all of those items again.

You can use the VLOOKUP or HLOOKUP function.

VLOOKUP is a powerful function in Microsoft Excel that allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).

See this FREE tutorial for help with VLOOKUP:

http://599cd.com/tips/excel/vlookup/?key=BlFAlEx