Can someone help me with formula
1. Lookup the word "IBQ Credit Card" from the top pic and find it in the bottom pic (Row 19)
2. Match the date in the top pic (Row 35) with the date in the bottom pic (column B)
3. Enter all the values in the bottom pic (column E) and enter these value in the top pic (row 42)
Note: the word "IBQ Credit Card" in the bottom pic can move horizontal so the formula has to be dynamic with looking for this word.
Thank you for your help.
Attaching a sample workbook with data would make it easier
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Your picture is unreadable, but the way I would do something like that is using the functions Match , Index and Offset, which when combined together are much more flexible than the the lookup functions
I've attached a booklet.
No matter how I tried, I could not find "IBQ Credit Card" in this RowLookup the word "IBQ Credit Card" from the top pic and find it in the bottom pic
Month Snowball Additional American Express Int'l Bank of Qatar
I notice that it is possible to match the Serial values of the Dates in Sheet1 to the Serial values in Sheet2.Match the date in the top pic (Row 35) with the date in the bottom pic (column B)
I'm not sure how to do what you want, since it is obvious that the attachment is not the same as your actual workbook.
Further, I assume that you want this to work for many entries.
Do you want a Macro that will fill in the blanks?
OR
Do you want a UDF that you can use in a Formula in Sheet1?
In either case, we will need an accurate example of the two sheets
Last edited by SamT; 09-03-2016 at 11:38 AM.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
maybe, just maybe, in cell D42 of sheet1:
=INDEX(Sheet2!$A$19:$E$26,MATCH(D$35,Sheet2!$A$19:$A$26,0),MATCH($A42,Sheet 2!$A$19:$E$19,0))
copy up/down/left/right and around.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote
