| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Looking for comparable data records between Sheet1 and Sheet2
In both sheet1 and sheet2 I have hundreds of records.
60% of the records in sheet1 are also in sheet2. If I concatenate 2 of the fields "LastName" and "Amt", can I insert a formula in a helper column (Sheet2) that will search sheet1 and bring back a "yes" if found, "no" if not...? =if(sheet2!B13&G13 = vlookup(sheet1!$B$5:$K$200, "yes","no")??? ANy help appreciated.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Threaded Mode
