prevsheet lookup error, what am I doing wrong?

[SafeDave]

Hi all, first post by a novice hope someone can help. We have a fleet fuel workbook with tabs for each month. Data arrives in .csv form and I straighten it out with a macro to clean up the columns and order it by vehicle registration.
Each car fills up a different number of times each month, so my attack was to VLOOKUP the vehicle reg on current sheet in E2 using the criteria in D2 and refer back to the first matching value found on the previous sheet, which would be column D, then take the value from the cell to the right of that (prevsheet col E) and fill current sheet E2 with the result.

I'm using
=VLOOKUP(D2,PrevSheet!D2:E300,2,FALSE)

But all I get is a popup titled "Update Values: PrevSheet"

I guess I'm missing something basic but don't know what - any suggestions?

 

[SafeDave]

I should have said, the info I'm trying to retrieve is the driver name, which doesn't come in on the fuel card data so I want to input it on the first sheet then pull it through subsequent sheets automatically.

Hi all, first post by a novice hope someone can help. We have a fleet fuel workbook with tabs for each month. Data arrives in .csv form and I straighten it out with a macro to clean up the columns and order it by vehicle registration.
Each car fills up a different number of times each month, so my attack was to VLOOKUP the vehicle reg on current sheet in E2 using the criteria in D2 and refer back to the first matching value found on the previous sheet, which would be column D, then take the value from the cell to the right of that (prevsheet col E) and fill current sheet E2 with the result.

I'm using
=VLOOKUP(D2,PrevSheet!D2:E300,2,FALSE)

But all I get is a popup titled "Update Values: PrevSheet"

I guess I'm missing something basic but don't know what - any suggestions?