Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0125· OpenAIAi2 WildChat-4.8M (AI2)

In google sheets, I've a sheet called "Elenco" with a column A with dates and a column B…

  1. User

    In google sheets, I've a sheet called "Elenco" with a column A with dates and a column B with invoices ID. In another sheet called "Sommario" I need a formula to get the date of a specific invoice ID from the sheet "Elenco".

  2. Assistant

    You can use the VLOOKUP function to retrieve the date of a specific invoice ID from the "Elenco" sheet in the "Sommario" sheet. Here is an example formula you can use:

    =VLOOKUP(A2, Elenco!B1:C100, 1, FALSE)
    

    In this formula:

    • A2 is the specific invoice ID you want to find the date for in the "Sommario" sheet.
    • Elenco!B1:C100 specifies the range in the "Elenco" sheet where the invoice IDs and dates are located. You may need to adjust this range based on the actual location of your data.
    • 1 is the column index of the date in the range specified. In this case, the date is in column B, so the column index is 1.
    • FALSE ensures an exact match for the invoice ID.

    Copy and paste this formula into a cell in the "Sommario" sheet where you want the date to appear. Make sure to adjust the range and column index in the formula based on the actual location of your data in the "Elenco" sheet.

  3. User

    Says its impossible to find the value

  4. Assistant

    Apologies for the confusion in the previous response. If the VLOOKUP function is unable to find the value, it could be due to various reasons such as mismatched data formats, leading or trailing spaces, or non-exact matches in the search range.

    To troubleshoot this issue, you can try the following steps:

    1. Check the data formats: Ensure that the data in both the "Elenco" sheet and the "Sommario" sheet are in the same format for the VLOOKUP function to work correctly.
    2. Remove leading or trailing spaces: Use the TRIM function to remove any leading or trailing spaces from the invoice ID before performing the VLOOKUP.
    3. Use the MATCH function: Instead of VLOOKUP, you can also try using the MATCH function along with INDEX to retrieve the date. Here's an example formula:
    =INDEX(Elenco!A:A, MATCH(A2, Elenco!B:B, 0))
    

    Again, make sure to adjust the ranges in the formula according to your data. This formula will return the date corresponding to the specific invoice ID in cell A2 of the "Sommario" sheet.

    If you're still facing issues after trying these steps, please provide more details about the data and the specific issue you're facing, and I'll be happy to assist further.