Vlookup to Access Dlookup


Joined
Jun 12, 2011
Messages
1
Reaction score
0
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
 
Last edited:
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top