IF function problem

[InterstateRentals]

We need help on this problem please!

Please see the attached file. Column B has a drop-down with three choices (RE/RO/RL).

First we need a formula in CELL B1 that can identify the cell in COLUMN B that has RE or RO or RL (note: only one cell in B4:B22 will have RE or RO or RL) and store it in B1.

Then we need a formula in CELL D1 that picks up the credit card number that corresponds to the RE or RO or RL in CELL B1.

Thank you for the help!

[FDibbins]

Try this in B1...
=INDEX($B$4:$B$10,MATCH({"RE","RO","RL"},$B$4:$B$10,-1))
and then use this in D1...
=INDEX($D$4:$D$10,MATCH({"RE","RO","RL"},$B$4:$B$10,-1))

[Fotis1991]

I don't think that you need a formula in B1.

Try this one in D1

Please Login or Register  to view this content.

[InterstateRentals]

AWESOME! Thank you both for your response.

We do want the value in B1, so we'll use Ford's solution.

Thank you for the help!!

ps Ford, I couldn't leave you a "reputation" ... you helped me recently and it won't let me leave another one for you ... sorry

[Fotis1991]

You are welcome and thanks for thefeed back & rep.

In this case, you can use in B1.

Please Login or Register  to view this content.

In D1

Please Login or Register  to view this content.