Microsoft Office Forums - View Single Post - Compair two pair of cells: function usage

Thread: Compair two pair of cells: function usage

View Single Post

Old

01-27-2023, 08:57 AM

mrgramm

mrgramm is offline

mrgramm uses Windows 10

Windows 10 mrgramm uses Office 2021

mrgramm uses Office 2021

Office 2021

Novice

Join Date: Jan 2020

Posts: 7

mrgramm is on a distinguished road

Default

Try =INDEX(Sheet11!$C$1:$C$3,MATCH(Sheet10!A1&Sheet10! B1,Sheet11!$A$1:$A$3&Sheet11!$B$1:$B$3,0))
Sheet11 is your sheet B and sheet10 is your sheet A

Reply With Quote