Hi, first let me thank you all for such a knowledge packed forum.

I am trying to utilise a barcode scanner to help me return details on
machinery, but for the moment I have manually typed in the serial numbers
till I get the formulae sorted.
On sheet 1 I have all the serial numbers in column A. I then need to Vlookup
A2, then A3 etc, to return details of each machine in column B, this means
changing the formula on every line, and there is a lot of machinery.

Is there a way I can use the indirect function with Vlookup that will use the
RC parameter to make a simpler line of formula? This way I can drag 286 lines
and paste the same formula into all of them.
I want to be able to click on any row in column B and it will look across at
column A on the same row for the serial number, and then retrieve the machine
details from the list I have on sheet 2.

Here is something like I wanted, but I obviously got it all wrong.
=VLOOKUP("RC[-1]",0),INDIRECT(Sheet2!$A$1:$F$200,2,FALSE)

Hopefully I learnt something from searching all the other posts here and
wasnt too far off the money..

Note, if I use this type of format, everything works at this stage.
=IF(A4="","",VLOOKUP(A4,Sheet2!$A$1:$F$200,2,FALSE ))

Many thanks for any sugestions.