Transferring data from one sheet to another just by adding a count.

[Islandsmgr]

Looking for the formula needed to transfer data from one tab to another just by adding a meal count. On the attached file for example:

When I add a meal count in D1 on the Fry Prep Board I would like column B to populate with the associated columns from the Fry Pars.

I just need the formula for one cell and I should be able to complete the rest, I believe it would be a VLOOKUP formula?

Thanks for any help,


Scott

[lts_ram]

Hi,
Welcome to the Forum.
It is appropriate to use HLOOKUP. Try in
D3 of "Fry Prep Board" Sheet
D3=HLOOKUP($D$1,'Fry Pars'!$A$1:$M$27,2,0)
D5=HLOOKUP($D$1,'Fry Pars'!$A$1:$M$27,3,0)
D7=HLOOKUP($D$1,'Fry Pars'!$A$1:$M$27,4,0) AND SO ON...
KEEP THE ROW NUMBER CHANGING IN SERIAL ORDER UPTIL LAST ROW

[Islandsmgr]

Thanks for the info, it worked great!

[arlu1201]

Thread posted in CS, hence closed.