Sheet 1 to have the fomula looking up A2 the arra Sheets are named Jan, Feb
etc so 12 which will be the array and only columns A & B with the result to
be what is in the second column

Hope that helps
Thanks

"Domenic" wrote in message
...
How many sheets do you have? How are they named?

Where are your tables located? Are they all located in the same range
of cells for each sheet?

In article ,
"SS" wrote:

Hi

Anyone know if it is possible to do a vertical lookup over multiple
sheets

Any ideas would be great

Thanks Shona