Select data by date inserted

[JohnD1954]

I am setting up a new excel book to be used from July 2020. In this book, I have two spreadsheets one to have data inserted by date i.e. date; profit; loss; balance. The other spreadsheet combines and analyses the data. i.e. on 27/7/2020 profit was $20001. I need a lookup formula to insert data according to date. Can you help me, please?

[#2]

@JohnD1954 Assuming that your data is in columns A:D on "Sheet1" and the date you want the profit (2nd column) for on another sheet in, for example B2, the formula in B3 could then be:

=VLOOKUP(B2, Sheet1!A:D, 2, FALSE)

It will pick-up the value from the 2nd column from the first four columns on Sheet1, where the date exactly matches the one you entered in B2.

Similarly, if you want to return the loss, pick-up the 3rd column or the 4th in case want to return the balance.

[#3 · Accepted solution]

@Riny_van_Eekelen Thank you I shall try that and let you know.

[#4]

Thanks @Riny van Eekelen it works :)