OK, so, what I need to do is a sort of look up where on sheet 1 in cell B1, i enter a formula that looks for the value in sheet1 cell A1 across all cells in sheet 2. When it finds the required value (which will be a word) somewhere in sheet 2 (it will be a unique word appearing only once in sheet 2), then return the cell row and column number of the cell it found the value in.

I know how to vlookup in the normal way and also how to return a cell row/column by using =CONCATENATE("(",COLUMN(), ", ",ROW(),")") but i can't manage to marry the two together

Sheet 1:

look value on Sheet1 A1 across all of Sheet2 and write cell row and column number in cell B1

look value on Sheet1 A2 across all of Sheet2 and write cell row and column number in cell B2

.........

<tbody>

</tbody>

Sheet 2

<tbody>

</tbody>

Any Idea how this can be acheived ??????

Many thanks in advance

I know how to vlookup in the normal way and also how to return a cell row/column by using =CONCATENATE("(",COLUMN(), ", ",ROW(),")") but i can't manage to marry the two together

Sheet 1:

look value on Sheet1 A1 across all of Sheet2 and write cell row and column number in cell B1

look value on Sheet1 A2 across all of Sheet2 and write cell row and column number in cell B2

.........

A | B | |

1 | Apple | (1, 2) |

2 | Dog | (2, 3) |

<tbody>

</tbody>

Sheet 2

A (col 1) | B (Col2) | C (col3) | |

1 | <blank></blank> | Apple | <blank></blank> |

2 | <blank></blank> | <blank></blank> | Dog |

3 | <blank></blank> | <blank></blank> | <blank></blank> |

<tbody>

</tbody>

Any Idea how this can be acheived ??????

Many thanks in advance

Last edited: