Need to read value from excel

Puneet · Nov 4, 2018

Hello,

I am attaching a file here i need to read Card A, Card B, Card C and Card D value datewise. How to achive this. Please help me out. Facing problem in attaching file. I am attaching excel screenshot.

Excel file Path
https://drive.google.com/open?id=1X2O5u1-lkdjHd8FDhdDvBV-V0f8AAYSSRiJuiR17LTY

VJR · Nov 5, 2018

Hi Puneet,

You can insert a two way vlookup formula in your sheet via Blue Prism, get the result and then clear the formula cell.

Puneet · Nov 7, 2018

Will you pls help my vlookup is not working.

VJR · Nov 7, 2018

This link would be helpful for you
https://exceljet.net/formula/two-way-lookup-with-vlookup

Post back how it goes with you.

sivagelli · Nov 7, 2018

hello, as suggested by @VJR you can use the two way lookup to get the value.

Card A formula is "=VLOOKUP(A17,A17:AY23,MATCH(Y5,A5:AN5,0),0)".

Puneet · Nov 7, 2018

Abarika · Jan 22, 2019

Puneet said:
Thanks @VJR @sivagelli

Please, are you satisfied with the answers? I think your question isn't all that clear. If I get you well, I think you need to use the Two-way lookup or double lookup to read the card column and the date row. See this article for some guidance: https://softwareaccountant.com/excel-double-lookup/