Please post your formula, your input data and the relevant part of the lookup table.
Do you have multiple Johns?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"007juk" wrote in message ...
|
| Niek Otten;581677 Wrote:
| Use FALSE as the 4th argument
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "007juk" wrote in message
| ...
| |
| | Hi,
| |
| | Can the following be done.
| |
| | I have the following formula in Sheet1 of my workbook.
| |
| | =VLOOKUP(B6,Sheet2!A2:BC499,5,)
| |
| | When cell A2 of Sheet2 is populated with the name John and cell E2
| | contains 'ABC' the formula works ok, but when cell A3 is populated
| with
| | the same name, but cell E3 has 'DEF' it won't display the text
| 'DEF'.
| | Can this be done so that each time I enter the same name in column A
| | with different data in column E it populates correctly.
| |
| | Many thanks.
| |
| |
| |
| |
| | --
| | 007juk
|
| Unfortunately, it is still displaying ABC when I wanted it to display
| DEF which is entered in Cell E3. I don't think vlookup is going to
| work. I habe also tried index/match function, but that doesn't work
| either.
|
| Thanks for your reply.... I'm puzzled with this one.
|
|
|
|
| --
| 007juk