Excel 2007 : formula needed to copy data from tab2 to tab1 if values match

I have a spreadsheet with two tabs. I need to create a formula that will automatically enters details in tab 1 if location number in tab one matches location number from tab 2. The full details are in tab 2.

HELP!

btw excel version 2007, not 2003

Hi Linzi. Welcome to the forum.

Please take a few moments to read the forum rules and then amend your thread title.

As a clue, you're probably looking for a LOOKUP, VLOOKUP or INDEX/MATCH

It will help to clarify your requirements if, when you update the title, you post a small sample workbook.

Regards

If you change the column headers to match on both sheets, you can use the following formula:

Cell D2: =VLOOKUP($A2&"",'UK Sites'!$A:$L,MATCH(D$1,'UK Sites'!$A$1:$L$1,0),FALSE)

Copy across and down.

If the column headers don't match, or can't be made to match, you'll need to put the relevant column number in the VLOOKUP instead of using the MATCH(...)

Regards

You're welcome. Thanks for the rep.

Regards, TMS