Formula to pick which table i want to search in.

[brianaclark1967]

Hi all,

I need a formula that searches through 1 of 3 tables when a certain keyword is entered.

Each keyword relates to 1 of the 3 tables.

I've attached a draft sheet as an example.

Many thanks

Brian

 

[Somendra Misra]

Hi,

See the file, I had defined a formula in name manager, go through it.

Regards,

 

[Khalid NGO]

Hi Brain,

I was confused where to put data, so put it on sheet1.

See the attached if it helps.

Regards,

 

[Khalid NGO]

SM Sir i've misunderstood something?

 

[brianaclark1967]

Hi Brain,

I was confused where to put data, so put it on sheet1.

See the attached if it helps.

Regards,

Hi Khalid,

I needed the results of the search to go into cell E5.

Regards

Brian

 

[Somendra Misra]

See the file.

Regards,

 

[brianaclark1967]

Hi Somendra,

That is awesome.

Thank you so much for your help.

Regards

Brian