Follow this topic

Last answered:

24 Jul 2023

Posted on:

24 Jul 2023

0

Resolved: Vlookup error when switching sheets

in Introduction to Excel / Using Lookup Functions (Vlookup) to Fill the Database Sheet

Formula give me error when i try to press FY2016 sheet to select the table array for Vlookup

2 answers ( 1 marked as helpful)

Instructor

Posted on:

24 Jul 2023

1

Hi NIghat,

Good to hear from you.

Please try using , instead of ; in the formula. Let's see if this will work.

Best,

Ned

Helpful answer

Posted on:

24 Jul 2023

0

yes the , worked . Thanks

Submit an answer

related questions

Olisa Kizito Clement

2

18

Resolved: Error In Introduction to Excel Practice Exam 3

Aniruddha Chourasia

0

18

TRUE and FALSE argument in Vlookup!

Mario Contreras

1

12

Why are we using SUMIF to transfer data instead of using VLOOKUP?

0

10

Error showing on cell #REF!

0

10

Error in the code column

1

8

Resolved: I face with "File not found!" error.

Abdul Aziz Baig

0

6

I am on the FTA Project.i want to extract total transfer ins and out,What is the error in the formul

0

6

Video Error Video_cloud_Err_Video_Retrieve_Failure