I'm using the following formula in order to look up a name in another
spreadsheet that corresponds to what's in B76, and its working fine.

=VLOOKUP(B76,'[2010 GR.xls]Hiring'!$E$4:$F$400,2,FALSE)

However, I need a new formula to do something similar, but its not working.
I need to look up the whats in B76 then go to the 2010 GR.xls file in the
Hiring tab and match it with whats in column E (like above), then return the
position title that's in column C.

Any help would be greatly appreciated!

=INDEX('[2010 GR.xls]Hiring'!$C$4:$C$7,MATCH(B76,'[2010
GR.xls]Hiring'!$E$4:$E$12,0))

change the 12 to 400 - I experimented with a small table
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"KC" wrote in message
...
I'm using the following formula in order to look up a name in another
spreadsheet that corresponds to what's in B76, and its working fine.

=VLOOKUP(B76,'[2010 GR.xls]Hiring'!$E$4:$F$400,2,FALSE)

However, I need a new formula to do something similar, but its not
working.
I need to look up the whats in B76 then go to the 2010 GR.xls file in the
Hiring tab and match it with whats in column E (like above), then return
the
position title that's in column C.

Any help would be greatly appreciated!

I believe this is what you are looking for:

=INDEX('[2010 GR.xls]Hiring'!$C$4:$C$400,MATCH('[2010
GR.xls]Hiring'!$E$4:$E$400,0))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"KC" wrote:

I'm using the following formula in order to look up a name in another
spreadsheet that corresponds to what's in B76, and its working fine.

=VLOOKUP(B76,'[2010 GR.xls]Hiring'!$E$4:$F$400,2,FALSE)

However, I need a new formula to do something similar, but its not working.
I need to look up the whats in B76 then go to the 2010 GR.xls file in the
Hiring tab and match it with whats in column E (like above), then return the
position title that's in column C.

Any help would be greatly appreciated!

Hi Luke, the formula didn't work. it needs to 1st look at cell B76 (on the
current tab), then go to the other file 2010 GR.xls and look in column E for
the match, then return the contents of column C in the same row.

"Luke M" wrote:

I believe this is what you are looking for:

=INDEX('[2010 GR.xls]Hiring'!$C$4:$C$400,MATCH('[2010
GR.xls]Hiring'!$E$4:$E$400,0))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"KC" wrote:

I'm using the following formula in order to look up a name in another
spreadsheet that corresponds to what's in B76, and its working fine.

=VLOOKUP(B76,'[2010 GR.xls]Hiring'!$E$4:$F$400,2,FALSE)

However, I need a new formula to do something similar, but its not working.
I need to look up the whats in B76 then go to the 2010 GR.xls file in the
Hiring tab and match it with whats in column E (like above), then return the
position title that's in column C.

Any help would be greatly appreciated!

Did mine work for you?
Bernard

"KC" wrote in message
...
Hi Luke, the formula didn't work. it needs to 1st look at cell B76 (on
the
current tab), then go to the other file 2010 GR.xls and look in column E
for
the match, then return the contents of column C in the same row.

"Luke M" wrote:

I believe this is what you are looking for:

=INDEX('[2010 GR.xls]Hiring'!$C$4:$C$400,MATCH('[2010
GR.xls]Hiring'!$E$4:$E$400,0))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"KC" wrote:

I'm using the following formula in order to look up a name in another
spreadsheet that corresponds to what's in B76, and its working fine.

=VLOOKUP(B76,'[2010 GR.xls]Hiring'!$E$4:$F$400,2,FALSE)

However, I need a new formula to do something similar, but its not
working.
I need to look up the whats in B76 then go to the 2010 GR.xls file in
the
Hiring tab and match it with whats in column E (like above), then
return the
position title that's in column C.

Any help would be greatly appreciated!