Forum Discussion
Based on condition populate 3rd vale
Hi, I have 3 column values in my excel and would like to populate 3rd value based on first/second col values. I tried with filters, If condition but couldn’t get results, how do I get this fixed? ...
Depends on each Excel version you are, that could be like
=XLOOKUP($A3&"="&$B3, 'Lookup values'!$A$3:$A$20 & "=" & 'Lookup values'!$B$3:$B$20, 'Lookup values'!$C$3:$C$20, "" )
Depends on each Excel version you are, that could be like
=XLOOKUP($A3&"="&$B3, 'Lookup values'!$A$3:$A$20 & "=" & 'Lookup values'!$B$3:$B$20, 'Lookup values'!$C$3:$C$20, "" )
Thank Sergai, it worked.
BNemuri , you are welcome
