Try to create a order form

[Olijan29]

Good evening

I was sat wondering if this idea is possible or not has been I while since I e excel
Wether could make an Order form up to speed things up at work

say column A was the product numbers and B was the description on sheet 1

Would it be possible if you typed the description in a cell on sheet 2 could a formula search through and paste the product numbers in the cell next to it

Many thanks

[6StringJazzer]

For this type of question it is better to provide an example file, showing what your data looks like, and what you want the result to look like.

Suppose on Sheet 2 you have the description in column A, you can put this in column B to look up the product number. This is for row 1 and you can copy down.

Please Login or Register  to view this content.

[Olijan29]

How do I add an attachment of an iPad

[Mandy11]

Go to Advanced and attach the spreadsheet.

[Olijan29]

It won't let me will only let me choose photos

[JO505]

This may give you some ideas.

Jim O

[6StringJazzer]

What application are you using on your iPad?