VLookup Issue
I work with spreadsheets a lot for my expediting position. Tracking lead
times. I am creating a status spreadsheet that has to pull information from several other spreadsheets as one report does not provide all information. Right now, I simply cut and paste new information in "working" spreadsheets and the formula is set to pull specific information (dates, quatities, etc.) from these working sheets. The problem is when I cut and paste new information, the Vlookup formulas always lose the table array information. It keeps the "working" spreadsheet name, but, not the total information to look in. Is there a constant that I can use in the formula, i.e. $ to keep this from happening...? -- Thanks!! Shonte |
VLookup Issue
Let's say you have the following equation:
=vlookup(B1,H1:I19,2,false) If you want it to keep looking in the same location, whether you copy the cells down or across, change it to: =vlookup(B1,$H$1:$I$19,2,false) "Shonte" wrote in message ... I work with spreadsheets a lot for my expediting position. Tracking lead times. I am creating a status spreadsheet that has to pull information from several other spreadsheets as one report does not provide all information. Right now, I simply cut and paste new information in "working" spreadsheets and the formula is set to pull specific information (dates, quatities, etc.) from these working sheets. The problem is when I cut and paste new information, the Vlookup formulas always lose the table array information. It keeps the "working" spreadsheet name, but, not the total information to look in. Is there a constant that I can use in the formula, i.e. $ to keep this from happening...? -- Thanks!! Shonte |
All times are GMT +1. The time now is 03:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com