Sasha2016
asked on
VLOOKUP works only in 941 rows...but returns error after that?
VLOOKUP stops returning correct value past row 941?
there are 471 filled rows, and my formula was looking at A2:E800, and it seemed to work fine.
I needed to increase that range to E10,000 and I noticed that returned values didn't match once I modified formula.
I was able to work it out that it errors at row 942 and on.
Spreadsheet with table array has formulas in column A (A2:A10000), but current data is filled up to row 471.
Not sure why it works only up to row 941?
File attached...Sheet4, cell D2 is the one I've been trying to change.
Thanks!
takeoffs-1.xlsx
there are 471 filled rows, and my formula was looking at A2:E800, and it seemed to work fine.
I needed to increase that range to E10,000 and I noticed that returned values didn't match once I modified formula.
I was able to work it out that it errors at row 942 and on.
Spreadsheet with table array has formulas in column A (A2:A10000), but current data is filled up to row 471.
Not sure why it works only up to row 941?
File attached...Sheet4, cell D2 is the one I've been trying to change.
Thanks!
takeoffs-1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome!
Once you read the second formula several times you will find it easier than the first one.
In the second formula, the MATCH function returns the row# if the lookup value (A2&D$1) is found in column A on Main List Sheet and if it returns a row#, the ISNUMBER function is evaluated to TRUE and VLOOKUP formula is evaluated then.
Once you read the second formula several times you will find it easier than the first one.
In the second formula, the MATCH function returns the row# if the lookup value (A2&D$1) is found in column A on Main List Sheet and if it returns a row#, the ISNUMBER function is evaluated to TRUE and VLOOKUP formula is evaluated then.
ASKER
Thanks!