**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.*