I keep getting NA# 'S not sure where i'm going wrong :(

[pepsi]

I'm working on this excel document and it keeps returning NA#'s for some of the results when i drag them down, its on the 'orders spreadsheet' under 'order value'

i'm working with the 'orders' speadsheet and the 'prices' spreadsheet

any help on how i can fix this error and where im going wrong would be great

thanks

[NBVC]

I think you need to make the lookup table reference absolute....

try:

=VLOOKUP(E2,Prices!$G$4:$J$10,D2+1)

copied down

[Andy Pope]

As it's an assignment I will give you a clue.

When you copy your formula down the reference to the lookup table is changing.
You need to make the reference to the prices table absolute.

[pepsi]

thanks alot for your help!
how did you do the absolute partin this ---- =VLOOKUP(E2,Prices!$G$4:$J$10,D2+1)

if i can remember you press one of the F buttons

thanks again

[NBVC]

Press the F4 key..

Everytime you press it, it toggles where the absolute ref is placed.