Using same formula in 2 places!!!

[Scorpion Steve]

Hey ppl!
Apologies I haven't said Thank you already for all of the great advice and help! THANKYOU you all!
ok, I have been busy with my project and stumbled across a nice easy problem!
I have a simple Hlookup forumla looking a data array.
As this data array is made up of dates across the year, the whole amount is too large to fit along one row. So, What they're done is split the data in half and run exactly the same data but underneath!
To help you imagine what I have, below is a simplified version.
_| A | B | C | D |
1 001 002 003 004
2| 11 432 189 190
3| 005 006 007 008
4| 37 829 292 10

I have the formula =HLOOKUP(T1,A1:D2,2,0)
BUT I need the formula to find the same thing but with the array looking at all of the data. =hlookup(t1,a1:d4,2,0) doesnt work and comes up with NA

Do I net two Hlookups?
eeks!

I would upload an image if anyone can tell me how to! :/
Thanks in advance

 

[AlphaFrog]

Try something like this...

=IF(NOT(ISERROR(HLOOKUP(T1,A1:D2,2,0))), HLOOKUP(T1,A1:D2,2,0), HLOOKUP(T1,A3:D4,2,0))

 

[Scorpion Steve]

Amazing work my friend!
Perfect!
Apologies for delay, I reinstalled windows and lost excel so haven't had chance to test! But now I have, Its great! thank you