Index formula to search different document, different sheets

[GPetcu]

Hello everyone.

Simple question and the answer is as simple as the question but I am probably to thick.

I have this formula "=IFERROR(IFERROR(INDEX(Sheet3!B:B,MATCH($C$1,Sheet3!G:G,0)),INDEX(Sheet3!B:B,MATCH($C$1,Sheet3!H:H,0))),"")"

I want to modify it so it will search a different document. So basically, I need to change the array "Sheet3!B:B" to another excel document but the problem is that I want the formula to search 2 sheets of that specific document. For ex: instead of Sheet3!B:B I would like for it to say the likes of Sheet1!B15 to B500 and Sheet2!C10 to C1000 if that makes sense.


Cheers

[shukla.ankur281190]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[GPetcu]

My apologies. I have now changed the title to reflect my problem.

Thank you

[shukla.ankur281190]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[GPetcu]

I have attached an example of that database that I would like the formula to search for values.
I have also attached a picture that shows what I need, but I do not know how to add another sheet after [test.xlsx]Sheet1!$B$4:$B$7$........

To make it more clear after [test.xlsx]Sheet1!$B$4:$B$7$ to add something the likes of [test.xlsx]Sheet2!$C$1:$C$71$

I hope this makes sens.

Thank you for taking the time to look at my problem.

Cheers

[shukla.ankur281190]

Couldn't get you dear. Can you please confirm me what would be expected result. All the values which are in Reg text Sheet3 matching with other workbook data...

[GPetcu]

All that I want to know is how can I adapt this formula (=IFERROR(IFERROR(INDEX(Sheet3!B:B,MATCH($C$2,Sheet3!G:G,0)),INDEX(Sheet3!B:B,MATCH($C$2,Sheet3!H:H,0))),"") ) to search for values on a different workbook (Database Test.xlsx in this case) instead of searching in Sheet3 of the Reg Test workbook.

[shukla.ankur281190]

Ok instead of Index you can use Vlookup. I wish to inform you that Vlookup can handle arguments after closing the other workbook and can update automatic the data once updated new one. As I have seen the workbook Database Text updated data is in different columns but headers are on the same row but Vlookup can work vertically.

May be you will need VBA coding....

[GPetcu]

Thank you Shukla

I will give it a try with Vlookup.

All that I need is to have a separate excel doc where if I input a car registration no I will receive all the details that I have in my database (separate excel doc) under that specific reg.
The function should be able to search 2 different excel sheets within the database as I have data separated by type of parking permit.

Thank you for taking the time to look at my request.

Cheers