Match function

rhaney

Board Regular
Joined
Sep 27, 2009
Messages
64
I need to use the match function to find values in one of several pages within a spreadsheet. Entries in Column A of the first page match the other spreadsheet page names.

Is it possible to match the value found in B3 of the 1st page within the page that corresponds with the value found in A3 using the data found in Column B:B of the matching A3 page? Match type is 0.

Thank you!

Robert
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
I need to use the match function to find values in one of several pages within a spreadsheet. Entries in Column A of the first page match the other spreadsheet page names.

Is it possible to match the value found in B3 of the 1st page within the page that corresponds with the value found in A3 using the data found in Column B:B of the matching A3 page? Match type is 0.

Thank you!

Robert
So, what kind of result do you want?
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
I need to use the match function to find values in one of several pages within a spreadsheet. Entries in Column A of the first page match the other spreadsheet page names.

Is it possible to match the value found in B3 of the 1st page within the page that corresponds with the value found in A3 using the data found in Column B:B of the matching A3 page? Match type is 0.

Thank you!

Robert

Looks like...

=MATCH(B3,INDIRECT("'"&A3&"'!B2:B100"),0)

Adjust the range to suit.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,985
Messages
5,526,063
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top