SOLVED

Based on condition populate 3rd vale

Copper Contributor

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? 
Pls advise 

5 Replies

Hi @BNemuri 

 

according to your description, it sounds like some IF statements. But in order to help you, we would need some more details, like what exactly are the rules to fill the third column.

Screenshots and information about your Excel version would also help.

 

Kind regards,

Martin

@Martin_Weiss 

 

Here are the details, where I have 3 columns with values in Lookup tab

BNemuri_1-1688575555099.png

In the MainSheet tab, I would like to auto-populate col3 based on the col1 & 2 

Ex: when I enter "SST" in col1 and "A" in col2, then it should populate "1" in col3.

BNemuri_2-1688575677415.png

 

Hope I provided complete details. I really appreciate your support on this.

 

Thanks

Bhaskar 

 

 

best response confirmed by Hans Vogelaar (MVP)
Solution

@BNemuri 

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

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@BNemuri 

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, "" )

View solution in original post