Another if question

[keepitfrozen]

I thought i had figured this out at some point the in the past but i cant seem to find any book marker or searches that help me out. So if this is another duplicate post, i'm sorry and just point me to a thread.

I have 2 dates that i want to compare and if they match return a value that is 2 cells underneath the 2 date. This needs to be dynamic and thats what's throwing me.

If Cell "sheet1!G9" matches the value in the cell range of "sheet2!E218:P218" , then just return the value that is 2 rows down in the corresponding cells range "sheet2!E221:P221".

And this answer be returned to Cell "sheet1!B13"

This way if i change the the value in "sheet1!G9" it will updated "sheet1!B13" with the correct information for that month.


I think i'm explaining this correct.. I appreciate any help you could offer.

MJ

 

[Jonmo1]

=HLOOKUP(Sheet1!G9,Sheet2!E218:P220,3,FALSE)

edit - good catch on the typo keepitfrozen

 

[keepitfrozen]

I keep getting a "Too many argument error" so i assumed you meant,

=HLOOKUP(Sheet1!G9,Sheet2!E218:P220,3,FALSE)

and that worked great, thank you very much for your help.

MJ