Index Match with Right Function

[garifuna]

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.

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

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

 

[Special-K99]

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)

 

[garifuna]

Perfect! Thank you for the help!