Fetching data based on cell value

[gan_xl]

Hi,

I have attached an example file for your reference.

My data present in the column locations 'AO' to 'AS', what I need is based on the value (1-5) in column 'AT' the data to be fetched from headers 1-5. If column 'AT' contains '2' then data of header '2' to be placed in column 'AU' and data of header '3' to be placed in column 'AV'.

Expecting formula rather than macro.


Thanks

[Pete_UK]

Put this in AU3:

Please Login or Register  to view this content.

and this in AV3:

Please Login or Register  to view this content.

then copy both formulae down.

Hope this helps.

Pete

[gan_xl]

Thanks Pete, it works.

[Pete_UK]

Glad to hear it.

You should ensure that column AT only contains numbers 1 to 4.

Pete