Forum Discussion
INDEX MATCH - Fill in a blank cell based on two matching cells
I need to fill in blank cells with valued cells based on matching cells in two different worksheets. The cells in MasterCAP[RFS_ID] must be filled in with the value from BESTRFS[BEST_RF...
Hi,
Please try to use the formula as the below syntax:
=INDEX(BESTRFS[BEST_RFS], MATCH(MasterCap cell B2, BESTRFS[ACAP],0))
Where:
BESTRFS[BEST_RFS] is the column of values you want to retrieve.
MasterCap cell B2 is the cell in MasterCap table that you want to match.
BESTRFS[ACAP] is the column that you want to match cell B2 in it.
There is an example in the attached workbook.
Hope that helps
Dear Haytham -
I replaced cell B2 with the column name (which was CAP in my case) and it worked like a charm. Many thanks for your help. Wishing you only good things.
Kindest Regards,
Mickey C.