Need to pull data from multiple columns only if value in column A

Hello RogueofDoE, first of all, welcome to the forum, yes that can be done, Please let me know how many times GL No.Can be same.

attempt2.xlsx

ok, so what you have i think is perfect im just having issue applying it to my sheet to i have attached a more complete version, it is still the same columns A,B, and J and they just need to go into the description, account and amount columns on the next tab. Thank you so much for your help.

if answer helps you click"*" add rep icon in the bottom left corner of my post and mark thread as solved.

The formula used in sheet completed is array formula( you need to type or copy paste the formula then hold control with shift and hit enter , you will see curly braces{} will surround your formula in formula bar, its the confirmation of array))

is this you are looking for ???

Change the references according to your sheets and data

Or just alternative

=VLOOKUP(A2,IF(Sheet1!$B$2:$B$11=B2,Sheet1!$A$2:$J$11,""),10,FALSE)

Array Formula (ctrl-shift-enter together)

Azumi

Hello, If your problem is solved mark the thread as solved go to thread tools---> mark as solved.
Thanks for the rep

we are very close now, the original one skipped the rows that did not have a value in the account column on the original tab but this one is just putting in 0. i do appreciate all the help.

Glad We Could Help !!

ok so were so close on this on solved the formula skips lines that dont have a value in the account field, but on attempt2 which has (as far as i can see) the same formula it does not skip said lines that have no value in the account spot it just fills it with 0's instead. If i could just get a little bit of help with my last issue i think we will be good. Thank you!