Excel - How to Use a VLOOKUP Formula - Expert Solution

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

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.