Vlookup to Access Dlookup

[RichMike]

Hi All, I can't figure this out. I can get a vlookup in excel to work but can't figure this out in access.....
=IF(VLOOKUP($G11,$A2:$E34,4,FALSE)<>1,IF(ISERROR((VLOOKUP($G11,$B2:$E34,3,FALSE)<>1)),VLOOKUP($G11,$C2:$E34,3,FALSE),VLOOKUP($G11,$B2:$E34,3,FALSE)<>1),VLOOKUP($G11,$C2:$E34,3,FALSE))

Combobox to select ID_Number.
Go into table - find ID_Number in column 1 and If column 4 is > 1 Look in column 2 for ID_Number. If column 4 is > 1 then Look in column 3. If at anytime column 3 =1 then show column 5

Example: If selected ID_Number = 159 the text box would return $40
column1 | column2 | column3 | column4 | column5
20..........|..............|..............|........1.....| $130
38..........|......159...|..............|........1.....| $40
100........|......230...|..............|........1.....| $20
159........|.......38....|..............|........2.....|
Hope that makes sense?

Thanks