Please help with Lookup

[vonmunchy]

Hi there,

Demo Sheet.xlsx

I have attached a demo sheet. What i want to do is look up find the exact match of column A (National ID) from sheet 1 and than fill the remaining columns for that row.

I hope you understand what im trying to say. Basically i have 2 sheets. Sheet1 with complete details and sheet2 with many details missing. So i want to find the exact match in sheet 1 and automatically fill the missing details with a formula.

http://s000.tinyupload.com/index.php...71644462262681
Demo sheet

Regards
Munsif

[Haluk]

Enter the following formula in cell B2 of Sheet2 and drag the cell towards right and down to fill the cells of the table.

Change ";" with "," depending on your local settings of Excel.

Please Login or Register  to view this content.

[vonmunchy]

Thank you for getting back. But in the case where id name is not in the same row?

[AliGW]

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.