Retrieve data from other sheet

[nvsanilkumar]

Sir

In the enclosed sheet. Sheet 1 has work order numbers. In the Sheet 2 I need to match the work order number and retrieve products departments and in charge names to sheet 1

Please help.

Thanks
Anil

[JapanDave]

What enclosed sheet do you speak of?

[Marcol]

There seems to be a problem with your attachment, it was returning an invalid link, now it's dissapeared altogether!

[Alf]

Perhaps like this?

Alf

[Marcol]

@ Alf
You could take your idea a step further and make the name "Data" dynamic, to allow the table to grow/shrink as required.
See this attachment

[Alf]

Hi Marcol

Excellent idea! Let's hope the OP appreciates it. At least I do and I'll save it in my file of Excel tips and tricks!

Regards

Alf

[Marcol]

@ Alf
If you are keeping the file for reference then it might be useful to add these notes

1/. For lists that are text only use this
e.g.

Please Login or Register  to view this content.

2/. For lists that are numbers only use this

Please Login or Register  to view this content.

3/. For lists that are both text and numbers only use this

Please Login or Register  to view this content.

4/. For lists that could possibly be either text or numbers only use this

Please Login or Register  to view this content.

[Alf]

Thanks again Marcol

I'm really impressed! I do collect this kind of valuable tips and tricks and add it to my "excel help" doc file, at moment this file is 196 pages long.

Alf

[nvsanilkumar]

Dear All

Thanks for all your support.

Regards
anil