Hi

1st, you can't use INDIRECT to valuate a formula - you can use it only to
return a text string as range. Like
=SUM(INDIRECT("Sheet1!A2:A10"))

2nd, why not simply something like this
=VÖOOKUP(A1,Sheet2!$A$1:$F$200,2,0)

Arvi Laanenemets



"outwest" <u19594@uwe wrote in message news:5d2158b6e59ec@uwe...
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.