Another if question

keepitfrozen

New Member
Joined
Nov 30, 2005
Messages
40
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
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
=HLOOKUP(Sheet1!G9,Sheet2!E218:P220,3,FALSE)

edit - good catch on the typo keepitfrozen
 

keepitfrozen

New Member
Joined
Nov 30, 2005
Messages
40
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,095
Messages
5,768,053
Members
425,451
Latest member
JohnBrooksBiddle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top