For each month, I want a formula that looks for TX ID and returns that value in cell
My best shot at the formula is as follows '=VLOOKUP(TABLE1[TAX ID],TABLE1,Table1[DATE],">"&"05/01/2022"
I have uploaded a sample workbook
Thanks
For each month, I want a formula that looks for TX ID and returns that value in cell
My best shot at the formula is as follows '=VLOOKUP(TABLE1[TAX ID],TABLE1,Table1[DATE],">"&"05/01/2022"
I have uploaded a sample workbook
Thanks
Maybe:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Could you please put formula into effect in sample spreadsheet I have attached, I learn much better seeing the formula play out on a spreadsheet.
Attached sample
Another aproach:
Please tryFormula:Please Login or Register to view this content.
In C23 copy across.
Formula:Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 12-08-2022 at 03:20 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you guys!
Glad to have helped. Please considder adding reputation to the answers of any helpers you think they deserve it.
If you want that click on * Add Reputation left below the answers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks