Get cell value from another cell adjacent to particular matching cell

[rahulbuddy]

Hello Guys,

I am making an excel file where, I want to retrieve a cell value from another cell next to that particular date.

So I have a exchange rate table with 2 columns, where in Column1 I have dates and in Column2 I have currency exchange rate for that particular rate. Lets say I have this data for 6 months.

In another column, I want to fetch that exchange rate value only for a particular date. Kindly look at image attached. Any help is much appreciated.

Thanks and Regards,
Rahul.

 

[ETAF]

=index(TRY Value range , match( cell with date , Date range in table , 0 ))

should do that for you - not sure of the columns or rows you have the tables in or if a different sheet

example attached

 

[rahulbuddy]

=index(TRY Value range , match( cell with date , Date range in table , 0 ))

should do that for you - not sure of the columns or rows you have the tables in or if a different sheet

example attached

Hello ETAF,

Appreciated your quick response. I did not get you, I am a complete newbie in Excel. Could you please elaborate more or make changes in workbook I have uploaded now and then share here.
I have attached the workbook for your reference.

And the exchange rate data (table on left) is on same sheet of workbook.

Regards.

 

[ETAF]

=IFERROR(INDEX($E$4:$E$18,MATCH(G5,$D$4:$D$18,0)),"")

 

[rahulbuddy]

=index(TRY Value range , match( cell with date , Date range in table , 0 ))

should do that for you - not sure of the columns or rows you have the tables in or if a different sheet

example attached

I think I am about to catch you with the help of your file.
Will keep you posted with update.

 

[rahulbuddy]

=IFERROR(INDEX($E$4:$E$18,MATCH(G5,$D$4:$D$18,0)),"")

Yo! You came like an angel.
God bless you dear.

Could you please suggest any source where I can start learning excel?
There are numerous website, courses and video but not sure from where I should start.

Many thanks again..

 

[ETAF]

your are welcom

lots of different sources , depends on how you want to learn, Books, youtube is now ver good - you just need to find someone who you can watch for a few courses . search youtube - learn excel , quite a few will come up -

lots of websites with a learning
I used to recommend many years ago -

Free Excel Tutorial at GCFGlobal

Microsoft Excel is the spreadsheet application in the MS Office suite. Get help organizing and calculating data in this Excel tutorial.

edu.gcfglobal.org

but have not used for 5-6 years now

This site may have some teaching sections - never looked

Subscribe to our FREE Excel Tips Newsletter & Get bonus ebook » Chandoo.org - Learn Excel, Power BI & Charting Online

The most Amazing Excel + Power BI Emails Bite sized & useful One email per week with powerful tips, resources and videos to get ahead in your work. Practical Real world examples of data analysis, charting, reporting and automation with Excel & Power BI. No faff, just stuff. Free stuff Bonus...

chandoo.org

Advanced Excel Class & Dashboard Training - Excel School from Chandoo

Advanced Excel skills will transform your career. In this advanced Excel class & dashboard training, I teach you - data analysis, reporting and dashboards using Microsoft Excel.

chandoo.org

As i say never used or looked for till now

I'm sure other members who have used my help - might be worth asking that as a new question