Forum Discussion

LauraB80's avatar
LauraB80
Copper Contributor
Feb 09, 2023

Formula Help

Hello - I am hoping someone might be able to help.  I have a worksheet which has a few tabs within it.  One of these is an input tab and another is running some formulas to do some calculations.

 

I need a formula which will look at a date (which has been input) from the input worksheet, find the same date in the calculation spreadsheet and identify the contents of a cell - from a column within the same row as the date it has just matched. 

I am not sure which formula to use to do this - would anyone know/?

 

Many thanks 

Formulas and Functions

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Feb 09, 2023

    LauraB80 

    =INDEX($F$3:$J$22,MATCH(A11,$E$3:$E$22,0),3)
    =VLOOKUP(A11,$E$3:$J$22,4,FALSE)

    You can try INDEX and MATCH or VLOOKUP. The VLOOKUP formula is in cell C11 in the example. 

     

    If you work with Office 365 or Excel 2021 you can apply XLOOKUP.