| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup:suddenly doesn't work for half the rows in the same wk.bk
I have a vlookup retrieving info from another page in the same workbook. To
make things easy I copy the first row of formulas to the rows below and it works up to a ceratin row, and the I get #N/A. The error description is "Inconsistent formula" and the trace has a line from the lookup value to the cell next to it and then a dotted line to another cell two rows up. I have no clue why there is this difference - I have changed cell formats both on the source page and in my report page; the formula is the same as the rows above (they work, btw) so what is the problem with the rest of the rows? Any comments or suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Threaded Mode
