Index Match with Right Function

garifuna

New Member
Joined
Jun 5, 2019
Messages
4
I have an index match that gives me results for prices with a string of text I want to remove. Example: USD 41.99

In a separate cell I have the RIGHT function to remove the "USD ", but I would like to have a single formula in one cell.

HTML:
=INDEX(Report!Q$2:Q$1000,MATCH(Main!A2,Report!D$2:D$1000,0))

HTML:
=RIGHT(G2, LEN(G2)-4)
 

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,327
That would have to be (just replacing G2 with your original formula)

=RIGHT(INDEX(Report!Q$2:Q$1000,MATCH(Main!A2,Report!D$2:D$1000,0)),LEN(INDEX(Report!Q$2:Q$1000,MATCH(Main!A2,Report!D$2:D$1000,0)))-4)
 

Forum statistics

Threads
1,082,500
Messages
5,365,935
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top