Lookup Table query

[peterderrington]

Morning,

i'm just after a little help, i have a table of data (Sheet "Data") and 2 columns, A= a date range & B= values

On a separate sheet (Result) i have 2 columns that are also labelled date range and data but with only the date range complete.

What i want to do is go through each date on the "Result" sheet and copy the associated value from the "Data" table, if the date doesn't exist in the "Data" sheet then i want it to return a zero.

I'm fairly sure i need a lookup and or match/index formula but i'm not sure of the syntax.

Can anyone help?

Thanks,

Peter

[AliGW]

Welcome to the forum.

Something like this:

=IFNA(VLOOKUP(lookup_value,data_range_columns_A_and_B,2,0),0)

[peterderrington]

Thats great thank you.

(as it stood it was B and C not A and B that held the info - my bad!)

It ended up as: =IFNA(VLOOKUP(A2,Data!$B$2:$C$287,2,0),0)

Could i have used =IFNA(VLOOKUP(A2,Data!B:C,2,0),0) as well?

[AliGW]

Yes, but using full column references when not necessary is bad practice, so no!!!