vlookup with result TRUE not updating cell
I'm using vlookup to populate sheet 2 from sheet1. This is working for part
of the spreadsheet, stops for 8 rows then continues working. According to the Function Arguments the lookup result is true, but no update takes place. Is it possible to see the cell value it thinks it's returning? The data in ascending order as required. |
vlookup with result TRUE not updating cell
It might help if you posted your formula(s)
-- Don Guillett Microsoft MVP Excel SalesAid Software "MEB310" wrote in message ... I'm using vlookup to populate sheet 2 from sheet1. This is working for part of the spreadsheet, stops for 8 rows then continues working. According to the Function Arguments the lookup result is true, but no update takes place. Is it possible to see the cell value it thinks it's returning? The data in ascending order as required. |
vlookup with result TRUE not updating cell
In the "Formula Auditing" toolbar, you can "evaluate formula" and go
ste-by-step through the formula to see what XL is seeing each step of the formula. Beyond that, it would help us if you posted the formula and a sampel of the data, and what you expect to see vs. what you currently see. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "MEB310" wrote: I'm using vlookup to populate sheet 2 from sheet1. This is working for part of the spreadsheet, stops for 8 rows then continues working. According to the Function Arguments the lookup result is true, but no update takes place. Is it possible to see the cell value it thinks it's returning? The data in ascending order as required. |
All times are GMT +1. The time now is 09:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com