VLookup using 2 drop down boxes

[trainer75]

Hi wonder if anyone can help me,

I am doing a datasheet where I am looking for information from a main data sheet to report onto a front page sheet.

Tab 1 is my main sheet where the info will be displayed
1st drop down box selects the tab to gather info from
2nd drop down box selects the area that I want the info from

Tab 2 is where is the info will be in range F1 to AX8

Tab 3 is the 2nd lot of info with the same range F1 to AX8

ColumnF G H I

Dartford 1 2 2
Emerald 10 9 3
Hams 0 0 0
Haydock 0 7 2
Langlands 2 1 0
Waltham 0 1 5
Northamp 6 1 0

If I want to choose the information when select Dartford for example and then want the data associated with that row, what would be my formula.
the one that I initially put in was
=IF(ISNA(HLOOKUP(A10,INDIRECT(P1&"!Wave1!f1:AX8"),7,0)=TRUE)," ",HLOOKUP(A7,INDIRECT(P1&"!Wave1!f1:AX8"),7,0))

A10 is the product number its calling against
P1 selects the correct tab from the drop down
F1:AX8 is the range (with F1 being the depot from drop down box as well, then G1:AX8 is the data I want to pull back)

I hope this makes sense.
Any help is greatly appreciated

 

[davesexcel]

Are you using Hlookup or Vlookup?

 

[trainer75]

Are you using Hlookup or Vlookup?

Im not 100% sure, I want to select the data from a drop down box which will come out of a row, like this
SHOP
TILL
TROLLEY
etc
then once ive selected that be able to pull back the data from that row in the columns.
Does that make sense?

Thank you