Question description:
This user has given permission to use the problem statement for this
blog.
I need to add an formula into this one:
=IF($L$1="","",VLOOKUP(TEXT($L$1,"000000"),'FRS102 BASE & GBP TB MAY 2018'!$E:$X,MATCH(A25,'FRS102 BASE & GBP TB MAY 2018'!$Q$3:$X$3,0)+3,0))
Solved by K. D. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/07/2018 - 08:21
Hello, I hope you are having a good day. I am here to help with your question.
User
20/07/2018 - 08:21
Hi, all good thankyou, yourself?
User
20/07/2018 - 08:21
Amazing!
Excelchat Expert
20/07/2018 - 08:21
all good, tahnk you
Excelchat Expert
20/07/2018 - 08:22
thank you *
Excelchat Expert
20/07/2018 - 08:22
so would you have a sheet or sample to share it so that we make the most out of the session?
User
20/07/2018 - 08:23
I do but unfortunately i am not able to share this
Excelchat Expert
20/07/2018 - 08:23
alright
User
20/07/2018 - 08:23
i am trying to add an iferror to the forumla i had sent above
Excelchat Expert
20/07/2018 - 08:23
I can understand
Excelchat Expert
20/07/2018 - 08:23
ok I'll help you with that
User
20/07/2018 - 08:23
the iferror should be related to the vlookup, so if this returns nothing it should say 0
Excelchat Expert
20/07/2018 - 08:24
you mean like this?
Excelchat Expert
20/07/2018 - 08:24
=IF($L$1="","",IFERROR(VLOOKUP(TEXT($L$1,"000000"),'FRS102 BASE & GBP TB MAY 2018'!$E:$X,MATCH(A25,'FRS102 BASE & GBP TB MAY 2018'!$Q$3:$X$3,0)+3,0),0))
Excelchat Expert
20/07/2018 - 08:25
I do have a concern for the formula, if I May
User
20/07/2018 - 08:25
Please do tell
User
20/07/2018 - 08:26
and thank you that worked :)
Excelchat Expert
20/07/2018 - 08:26
the fixed references are something to look out
Excelchat Expert
20/07/2018 - 08:27
I see that reference to L1 is fixed in an absolute way
Excelchat Expert
20/07/2018 - 08:27
copy pasting of formula will always look for L1
Excelchat Expert
20/07/2018 - 08:28
You might know this, but I will go ahead and share with you anyways. If you want a column to be fixed, the dollar sign should be just with the letter
Excelchat Expert
20/07/2018 - 08:28
if the row needs to be constand then the dollar sign is to be with just the number
User
20/07/2018 - 08:29
Yes, so the account number we are looking for will always be in L1
Excelchat Expert
20/07/2018 - 08:29
perfect. This was just for info as I wasn't sure if the formula had to be used elsewhere
Excelchat Expert
20/07/2018 - 08:30
Were you familiar with that already?
User
20/07/2018 - 08:30
It was just for this document :)
User
20/07/2018 - 08:30
Yes, I was ! :)
Excelchat Expert
20/07/2018 - 08:30
amazing
Excelchat Expert
20/07/2018 - 08:31
Is there anything else that i could help with?
User
20/07/2018 - 08:31
That's all, thank you so much!
Excelchat Expert
20/07/2018 - 08:32
hope I answered your question satisfactorily. I would love to receive your feedback.
Excelchat Expert
20/07/2018 - 08:32
Have a fantastic day :)
Excelchat Expert
20/07/2018 - 08:32
If you wish, you can end the question and proceed to rating.
User
20/07/2018 - 08:32
you too :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
