Hi all - I am no excel whiz at all so if there is a solution you will have to explain it to me like an alien! .. i had to google and try multiple times to figure out how to do a xlookup! but i finally got there and now this is my problem...
basically on one sheet i have a column with dates and a column with trading names, i want to look up a certain date so for example below 01/01/2024 and for it to return every trading name that has that date next to it, however i have replicated what is happening in the far right column in the picture below, it will return the same trading name on every line until it hits the date I'm looking for again, so if there are 10 trading names with different dates before it finds 01/01/2024 it will fill every cell with the trading name i want 10 times.
what i would like is for it to only bring back the names i need in a list one after another so like this:
Name 11
Name 12
Name 20
Name 27
is this possible?
the formula I'm using is below 'SFI2023' is my sheet name
Many thanks!
basically on one sheet i have a column with dates and a column with trading names, i want to look up a certain date so for example below 01/01/2024 and for it to return every trading name that has that date next to it, however i have replicated what is happening in the far right column in the picture below, it will return the same trading name on every line until it hits the date I'm looking for again, so if there are 10 trading names with different dates before it finds 01/01/2024 it will fill every cell with the trading name i want 10 times.
what i would like is for it to only bring back the names i need in a list one after another so like this:
Name 11
Name 12
Name 20
Name 27
is this possible?
the formula I'm using is below 'SFI2023' is my sheet name
Many thanks!
