How to use lookup or such function to get data from anthoer sheet

How to use lookup or such function to get data from another sheet of the same workbook?

in the TOFORUM.xls

Column A is filled with scrips, Columns B to X have various value for each A column scrip.

Now i need to, enter just scrip name in "Sheet1"'s A column and get results. If a scrip is not in FO list it should also display "N/A" in all columns.

Thanks

Originally Posted by JohnTopley

Try

Great Thanks. But when the non existing (in FO sheet A column) input is put in sheet1's A column, instead of N/A it brings someother value.

Try this:

=IFERROR(VLOOKUP($A2,FO!$A$2:$X$100,COLUMNS($A:B),FALSE),"")

Originally Posted by Glenn Kennedy

Try this:

Thanks It solved. Great.

You're welcome...