Excel Formula
Closed
Toni
-
1 Apr 2012 à 09:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Apr 2012 à 18:18
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Apr 2012 à 18:18
Related:
- Excel Formula
- Grade formula in excel marksheet - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
2 responses
sg714
Posts
2
Registration date
Sunday 1 April 2012
Status
Member
Last seen
1 April 2012
1 Apr 2012 à 19:51
1 Apr 2012 à 19:51
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
2 Apr 2012 à 18:18
2 Apr 2012 à 18:18
You need to use VLOOKUP function
2 Apr 2012 à 00:40
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.