Repercute value on other sheet with auto-detect

0 votes

So here's my Sheet 1 "Portefeuille" :

Sheet 1 - Portefeuille

My goal is to have it automatically update the K9 cell of Sheet 1 (which also corresponds at Symbole CW8) with the actual value of K9 plus the value placed on H9 in Sheet 2 whenever it detects a new line with Symbole CW8 on Sheet 2.

Sheet 2 - Trx

Can you please help me ?

Jan 29 in Others by Kithuzzz
• 34,260 points
60 views

1 answer to this question.

0 votes

Try in K9:

=INDEX(IFNA(VLOOKUP(C9:C; Sheet2!B:H; 7; 0)))
answered Jan 29 by narikkadan
• 59,740 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

VBA Help to find a column based on header value and cupy it to an other worksheet

You can break out the "copy column ...READ MORE

answered Jan 26 in Others by narikkadan
• 59,740 points
112 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

answered Feb 6 in Others by narikkadan
• 59,740 points
78 views
0 votes
1 answer

Struggling to move object based on the value to respect sheet

If you are not moving many rows ...READ MORE

answered Feb 14 in Others by Kithuzzz
• 34,260 points
49 views
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 59,740 points
264 views
0 votes
1 answer

How to split text values by a delimiter?

The Split function is what you are looking for: =Split(A1, ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 59,740 points
184 views
0 votes
1 answer

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 59,740 points
109 views
0 votes
1 answer

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 59,740 points
2,948 views
0 votes
1 answer

Transpose column on one sheet to row on another, with linking

select A1:J1 in worksheet B and enter: =TRANSPOSE('worksheet ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 59,740 points
214 views
0 votes
1 answer

Excel create an Index on the first sheet with links to subsequent sheets

This seems to be a potential duplicate ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 59,740 points
222 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP