Find out the exchange rate for a specific date.

[eXtremer]

Hi guys,

Need some help in excel.

In the first column there are some DATES and I need to find what was the exchange rate for that dates.
In the second and third columns is the DATE and the exchange rate.
So column 1 has to check the date from column 2 in order to know the exchange rate (that's in column 3).

The file is uploaded here and here(mirror). [direct link no filehosting]

I would really appreciate your help,
Thank you in advance.

 

[Sektor]

= index(c:c,match(a2,b:b,0),1)

 

[kidwispa]

By the looks of it you just need a vlookup formula...

in Excel 2007 or newer use this in cell D2 and copy down:

=IFERROR(VLOOKUP(A2,B2:C945,2,0),"-")

For older versions of Excel:

=IF(ISERROR(VLOOKUP(A2,B2:C945,2,0)),"-",VLOOKUP(A2,B2:C945,2,0))

For any dates that don't have a match a "-" will be shown...

 

[AlphaFrog]

Put this in D2 and copy down

=VLOOKUP(A2,B:C,2,0)

 

[eXtremer]

=index(c:c,match(a2,b:b,0),1)

When I press eneter it says "error formula"....newbie in excel, where should I paste it ? Thanks.

=IF(ISERROR(VLOOKUP(A2,B2:C945,2,0)),"-",VLOOKUP(A2,B2:C945,2,0))

For any dates that don't have a match a "-" will be shown...

Same question, how to use it ? Thanks

 

[kidwispa]

Both the vlookups and index/match formulas work fine for me when dropping into your sheet... how did you paste them in?

Have just noticed as well that I forgot to include absolute cell references in the formula... use this instead...

=IF(ISERROR(VLOOKUP(A2,$B$2:$C$945,2,0)),"-",VLOOKUP(A2,$B$2:$C$945,2,0))

 

[Sektor]

All is correct. What is your parameters delimiter?

 

[eXtremer]

Both the vlookups and index/match formulas work fine for me when dropping into your sheet... how did you paste them in?

Have just noticed as well that I forgot to include absolute cell references in the formula... use this instead...

=IF(ISERROR(VLOOKUP(A2,$B$2:$C$945,2,0)),"-",VLOOKUP(A2,$B$2:$C$945,2,0))

Just copy/paste in the first cell of D columns, then enter...

All is correct. What is your parameters delimiter?

Sorry, don't know what is the "parameter delimiter"

Could someone upload the result so I would know how to make it work...
Thanks.

P.S. Office 2003

 

[Sektor]

Here

 

[eXtremer]

kidwispa, Sektor - thank you a lot guys

Did the same thing, but it didn't want to work in my case, doesn't matter now, everything good.