IF any value from column match cell

[Olejeek]

Hello,

Sorry if it's newbie question, however I tried different solutions ( "=IF(A2=B2, C2)", "=IF(MATCH(..." ) that didn't helped me. So I came here asking for a help. I'll try to describe. I have 2 columns, currency rate that are date-related, so I need to transfer somehow these rates to my column depending on my column dates. Please see the screenshot where I tried to visualize my request. Thank you in advance for any posts.

 

[alansidman]

In E3 type =vlookup(D3,$A$3:$B$8,2,0) The A3:B8 should be A3:B and last row of rate data.

 

[Joe4]

Welcome to the Board!

A VLOOKUP formula will do that for you.
So, in cell E3, you would have:
=VLOOKUP(D3,$A$3:$B$100,2,0)
and copy down for all rows
(not sure exactly where your data ends, so I used 100)

See here for details on VLOOKUP: VLOOKUP function in Excel

 

[Logit]

Not tested here due to lack of having your excel sheet to practice with.

Try this : =VLOOKUP(D3,A3:B50,2,FALSE)

The formulas goes in E3 and copied down the column

 

[Logit]

Well ... what are the chances of receiving three answers ... all at the same time ?

 

[Joe4]

Try this : =VLOOKUP(D3,A3:B50,2,FALSE)

The formulas goes in E3 and copied down the column

Don't forget to lock your lookup range, if copying down!
=VLOOKUP(D3,$A$3:$B$50,2,FALSE)

 

[RAJESH NATH]

New Microsoft Excel Worksheet (3).xlsx
	A	B	C	D	E	F
1	DATE	RATE		DATE	RATE	RATE
2	07-01-2020	1.1198		07-02-2020	1.12	1.12
3	07-02-2020	1.12		07-02-2020	1.12	1.12
4	07-03-2020	1.1286		07-02-2020	1.12	1.12
5	07-04-2020	1.1224		07-03-2020	1.1286	1.1286
6	07-05-2020	1.1224		07-03-2020	1.1286	1.1286
7	07-06-2020	1.1224		07-03-2020	1.1286	1.1286
Sheet1

Cell Formulas
Range	Formula
E2:E7	E2	=VLOOKUP(D2,$A$2:$B$7,2,FALSE)
F2:F7	F2	=INDEX($B$2:$B$7,MATCH(D2,$A$2:$A$7))

 

[Olejeek]

Wow, I didn't expect for such quick replies, i'm super glad to be here and for all received posts. So, the result is what I expected and =VLOOKUP did what I requested. It will greatly simplify my routine work Thank you all!