lookup Formula

Hi,

I am trying to use the lookup formula and getting nowhere.

Firstly i would like to be able to grab information form a second tab and put it into the first tab.

Secondly i would like to be able to grab information from a second file.

Is this possible?

Thanks,26.8.15.xlsx

Hi,

Try the following formula:

In D7:

=INDEX('Tab 2'!D$4:D$9,MATCH(E7,'Tab 2'!E$4:E49,0))

In F7:
=INDEX('Tab 2'!F$4:F$9,MATCH(E7,'Tab 2'!E$4:E49,0))

Thanks for the reply CB

How do i look up from another file?

Do i need a different formula to look up a different file and link up IDS?

Hi,

No, you can modify the same formula to fetch the details from a different file.

For Eg,

If you want to lookup the details from 27.8.15.xlxs file, the formula would change as following.

=INDEX('[27.8.15.xlxs]Tab 2'!D$4:D$9,MATCH(E7,'[27.8.15.xlxs]Tab 2'!E$4:E49,0))

Oh thats great.

Thanks Very much

How does it know where to find the link? what if its on a common drive?

Thanks

Hi CB,

That formula does not seem to be working for me. The file i am trying to link to is located on a commn drive with plenty of sub folders.

Hi Adamlee,

In that case you would have to update the folder path in the formula. Keep the file (that you are trying to link) open when you Enter the formula & the formula will automatically update the folder path.

Hi CB

=INDEX('[XXXXXXXXX]XXXX'!$F$8:$F$8194,MATCH(H3480,'[XXXXXXXXXXXXX]XXXXX'!$H$8:$H$8194))

Can you see what wrong with this formula? It is not picking up the correct point.