Help with 2 sheets with data to work together

[Guest]

I have two worksheets. One is named order the other is inventory. Inventory
has info in a-g, numbered down 4-400. I want to enter a number in sheet
order 4-400 and it pulls all the info from inventory sheet a-g and
automatically fills it in just by inputing one of the numbers in a4-a400.
Is it possible and can anyone help me with it. I just can't seem to get the
formulas right.
Thanks

 

[Guest]

Please give me a green tick if you like this!

1 sheet INVENTORY. Insert a new column A, before all your other data, and
call it "Ref". You now have 8 columns A:H.

2 in cell A4 and all the cells below, use the formula =ROW()
inventory. I am using this like a reference for your row.

3 you now have something like this:
INVENTORY
Ref col1 col2 col3 col4 etc
=ROW()
=ROW()
=ROW()

4 in sheet ORDER, let's imagine that cell A3 is the cell where you want to
type a row number, and have data pulled into cells B3:H3 from INVENTORY based
on the row number you type in.

Cell A3 is blank at first

Cell B3 formula is =VLOOKUP($A3,INVENTORY!$A:$H,COLUMN(),0)
You can extend this across to cells C3:H3.

When you type a value into cell A3, cells C3:H3 will display the relevant
data for that row from INVENTORY.

If you have not quite used the same 8 columns as me, you should just play
with that COLUMN() number. This tells excel how many columns to count across
from column A before it reports back the value it is looking for. You can
maybe use COLUMN()+1, or COLUMN()-3 etc

Try this first and reply if it doesn't give you what you need.