Need help coding this excel statement in Access

[BrianP1]

Hi I have this code happening in Excel, would like to do it in Access but do not know how. Can someone help?

=IFERROR(VLOOKUP($AG5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($M5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($N5,VST!B$11:C$85,2,0),IFERROR(VLOOKUP($AC5,VST!B$11:C$85,2,0)," No"))))

 

[stumac]

That's not really enough information to help:

Where are you looking up the data from in access (multiple tables?) where are you wanting to display it?

 

[BrianP1]

That's not really enough information to help:

Where are you looking up the data from in access (multiple tables?) where are you wanting to display it?

I want the data to display in the table the main data is in. The section that the lookup is searching through is in another table in the database.