searching multiple fields

  1. N

    Paste multiple lines from single point of reference

    I want to copy multiple lines from one sheet that have the same reference number into another sheet, any ideas how? e.g. all the rows that have the ref: 123 <tbody> Ref Info1 Info2 Info3 123 wer asd uio 456 ert dfg wer 123 xxy bbg yyhj 123 wer asd ffg 456 erg wer asd </tbody>
    • nickamongo
    • Thread
    • asd copy & past rows duplicate row searching multiple fields wer
    • Replies: 5
    • Forum: Excel Questions
  2. K

    Searching the values with mulltiple condition

    Hello Champions, I have a query, where I need to search a value from table with multiple condition. Using the Vlookup, I can get only look/search only one value, however, I need to search with two conditions. Here is Example: Database: <tbody> Col A Col B Result A 1 X B 2 Y C 3 Z...
  3. B

    Simultaneous search of two fields which are in separate tables.

    I am working on a form that I need to be able to search based on two fields located in separate tables. The tables are joined in a one to many relationship. Do I have to start with a query?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top