I have included the formula below in a workbook to identify a 5-minute time interval for a specific time entered in E2. I paste new data in E2 on a weekly basis. Suddenly, VLOOKUP is returning N/A rather than the interval. If I select E2 and manually re-type the time or even if I just press enter, VLOOKUP returns the correct interval value.
=IF(E2="","",VLOOKUP(E2,tables!$G$2:$H$289,2))
Last edited by JamieJBrown; 08-18-2009 at 06:05 PM.
Hi Jamie, and welcome to the forum.
My guess is cell E2 is being formatted as text, and it's not being found in your lookup table. Perhaps try:
=IF(E2="","",VLOOKUP(E2+0,tables!$G$2:$H$289,2))
Re: VLOOKUP is not automatically updating
Hello Paul...thank you so much - that corrected my problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks