Excel Formula
Closed
Toni
-
Apr 1, 2012 at 09:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 2, 2012 at 06:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 2, 2012 at 06:18 PM
Related:
- Excel Formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
2 responses
sg714
Posts
2
Registration date
Sunday April 1, 2012
Status
Member
Last seen
April 1, 2012
Apr 1, 2012 at 07:51 PM
Apr 1, 2012 at 07:51 PM
I hope I'm understanding your question correctly. I think all you need to do is go to the cell in sheet 1, type =, and then click the sheet 3 tab, and select the cell you want. Then push enter. That should be it!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 2, 2012 at 06:18 PM
Apr 2, 2012 at 06:18 PM
You need to use VLOOKUP function
Apr 2, 2012 at 12:40 AM
Sheet 1 is an invoice, column C is a number 1-600 (matching column 1 on sheet 3), column E is an 'Item Amount' which will later be used with other figures to work out the invoice amount (matching column 2 in Sheet 3. There are many items on on invoice.
Sheet 3 is 2 columns of info as mentioned above.
What i want to do is only reference the number (1-600) for the invice and the 'Item Amount' for column E should automatically be pulled through from sheet 3 matching the corresponding number i have typed in?
Hope i have explained it better.
Thanks for your help, i am stumped and i know it can be done.