How to search a value previous cell based on formula

[ashish]

Hello,
I want to search a previous value in a table from a field if a condition is met. I can do this very easily in MS Excel using the formula: =IF(A2=A1,D1,C2)
Can someone please help? Any suggestion to do this in MS Access will be highly appreciated.
PS: The result in the green cell is what I am expecting to see in MS access.

MO Numb	UP Die	Die	First Die
7894300	UP00297	GLO805/8	GLO805/8
7890323	UP04672	GLO1557/2	GLO1557/2
7890323	UP04672	GLO1557/1	GLO1557/2
7894299	UP04672	GLO1557/1	GLO1557/1
7894299	UP04672	GLO1557/2	GLO1557/1
7894307	UP08921	3-6138/A	3-6138/A

[smithse]

Hi ashish,

Table sorts would make this a bit difficult. It appears you might be trying to extend functionality of Excel into Access. What exactly does your data store and if you are moving to to Access, there may be a better way to structure your tables.

[ashish]

Hi,
Thanks for advising about the question I asked. I have searched for this question on many blogs and finally settled down with MS excel file (with formula) and linked with MS Access as a table. I am calling the Excel table with a VBA which clears the contents of the cell and then copy and paste to Excel file which calculates the fields as per the formula. Since the excel file is linke with MS access so Access reads the calculated field to get the required results.
Hope this helps someone else. Not a ideal solution but Access lacks this feature as it is not a spreadsheet but a database.