| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking sheet - Formula Match Exact or select next row and cell
I am trying to set up a formula linking three sheets ( later books) pulling
information from one sheet only if it matches a second sheet, otherwise I need it to check the next row and cell until it comes up with a match, then print the information in a cell? So far: =IF(ISNA(MATCH(Sheet3!B2,Sheet3!B:B,0)),"",INDEX(S heet3!A:A,MATCH(Sheet3!B2,Sheet2!B:B,0))) It will not check further rows if sheet2!B2 does not match. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Exact() with VLookup or Match | Excel Worksheet Functions | |||
| how do i select a column when using "exact" formula? | Excel Discussion (Misc queries) | |||
| Formula for cell=exact(left...&2) | Excel Discussion (Misc queries) | |||
| Match name not exact | Excel Worksheet Functions | |||
| Getting an exact match | Excel Worksheet Functions | |||
Hybrid Mode
