Index Match Across Multiple Sheets

[michelleponan]

Dear Everyone,

I basically wants to know if I can use index match across multiple sheets.
Please see attachments.

I have worksheet "Summary" and multiple sheets to search for values (PIC009, PIC010, PIC011) I want to return the value of row C in "Summary" using index match.

Thank you.

Regards,
Michelle

 

[PCosta87]

Hi Michelle,

For instance, for the intersection of PIC009 with "Le" you would get 10,3 correct?

If so, since the value to lookup is on the left of the value you wish to return, I simply used Vlookup, but indexmatch does the same.

Please see attached

Regards

 

[michelleponan]

Hi PCosta

Thank you. Yes this works too

Regards
Michelle

 

[PCosta87]

Hi PCosta

Thank you. Yes this works too

Regards
Michelle

You are welcome

 

[michelleponan]

Dear PCosta,

Do you happen to know how to permanently convert my combobox 3 and 5 into integer. It's because it always converts to text and I need it as number.
Thanks

Regards,
Michelle

 

[PCosta87]

Dear PCosta,

Do you happen to know how to permanently convert my combobox 3 and 5 into integer. It's because it always converts to text and I need it as number.
Thanks

Regards,
Michelle

Hi Michelle,

Not really sure what you mean... looking at the file, combobox3 is linked to sheet(2nd Moment of Area), cell B6, correct?.
The possible inputs there are {Type A, Type B, etc) and not numbers.
"Type A" can't be converted to integer as it is not a number.

Can you please elaborate?

Regards