allard jansen
New Member
- Joined
- Sep 5, 2012
- Messages
- 6
Mike great as always, but tell me can you as well replace in work sheet were you use a combination vertical lookup and Match,use Horizontal lookup in stead of Match? What is the advantage of Match to HLookup which I use to select the correct exchange rate with its date , my example is here =IF(ISERROR(VLOOKUP(H4,$O$<wbr style="color: rgb(51, 51, 51); font-family: arial, sans-serif; font-size: 12.727272033691406px; line-height: 16px; background-color: rgba(255, 255, 255, 0.699219); ">*7:$AB$14,HLOOKUP(MONTH(G4)&YEA<wbr style="color: rgb(51, 51, 51); font-family: arial, sans-serif; font-size: 12.727272033691406px; line-height: 16px; background-color: rgba(255, 255, 255, 0.699219); ">*R(G4),$Q$3:$AB$4,2,1),FALSE)),<wbr style="color: rgb(51, 51, 51); font-family: arial, sans-serif; font-size: 12.727272033691406px; line-height: 16px; background-color: rgba(255, 255, 255, 0.699219); ">*" ",VLOOKUP(H4,$O$7:$AB$14,HLOOK<wbr style="color: rgb(51, 51, 51); font-family: arial, sans-serif; font-size: 12.727272033691406px; line-height: 16px; background-color: rgba(255, 255, 255, 0.699219); ">*UP(MONTH(G4)&YEAR(G4),$Q$3:$AB<wbr style="color: rgb(51, 51, 51); font-family: arial, sans-serif; font-size: 12.727272033691406px; line-height: 16px; background-color: rgba(255, 255, 255, 0.699219); ">*$4,2,1),FALSE))
I can send you the whole excel file were I use it or my client use it
allard
Just to give an idea of the problem
<tbody>
</tbody>to select the relevant exchange rate the VLookup combines transaction original currency date and the array with currencies and dates vertically
<tbody>
</tbody>[FONT=arial, sans-serif] and H lookup is for horizontally selecting month and year the right exchange rate in relevant exchange rate. Can Match do the same?[/FONT]
I can send you the whole excel file were I use it or my client use it
allard
Just to give an idea of the problem
<colgroup><col><col><col><col span="2"></colgroup><tbody> </tbody> | ||||||||||||||||||||||||
<tbody>
</tbody>
<colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>