Hi,
PFA the attached sheet and please help me in getting the formula. I need to match col A and col C with the another sheet of col A and col C and need the value in col B based on the "base data" sheet.
Thanks,
Karthik
Hi,
PFA the attached sheet and please help me in getting the formula. I need to match col A and col C with the another sheet of col A and col C and need the value in col B based on the "base data" sheet.
Thanks,
Karthik
Hi,
The below formula in B2 - Must be entered with Control+Shift+Enter keystrokes
=INDEX('base data'!$B$1:$B$5,MATCH(A3&C3,'base data'!$A$1:$A$5&'base data'!$C$1:$C$5,0))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks