formula dependent on text in adjacent column

[jrtaylor]

I have a datatable which has a column containing up to 25 different text codes (which are currency pairs).

I need to insert a specific number (as seen in the attached example) in a second column. This number depends on the text in the first column.

I suspect this is very simple but at the moment, not for me!

Thank you very much.

[DonkeyOte]

Simplest solution...

Create a table of your unique pairs - in left column the pair code, right column the factor, let's say for arguments sake this was in Y1:Z25

You can then use VLOOKUP against the above table to retrieve the appropriate factor based on the code, eg:

F10: =VLOOKUP($E10,$Y$1:$Z$25,2,0)
copied down

Going forward, by simply adjusting the lookup table factors and codes you can alter all of your calcs in F simultaneously.

[Palmetto]

Well DKO beat me to the punch, but here's a working example.

The lookup table was created using Advanced Filter.

[jrtaylor]

Thanks! Prob. Solved.