Hi Team,
Was looking for some assistance in creating a table with some Static data using If and Then Formulae.
Attached is my output that I am looking for between column A-D.
Just a simple logic, that if i Select my Currency (Col A), my next columns should have the dropdowns as per my static data.
This would help me receive my final output.
Can you please help.
In D2
=INDEX($I$3:$N$5,MATCH(A2,$H$3:$H$5,0),MATCH(B2,$I$1:$N$1,0)+(C2="Pay"))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Re: If and Then Formula with Validations
Got the solution bro...
Check the file..
Don't forget to click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks