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
Hello,

I have a 2 colunm set of info on Sheet 3 in a spreadsheet (Column A numbers listed 1-600, and column B corresponding figures per number) which i need to use within a calculating sheet on sheet 1.

For example. If i type in number 22 in cell 1C on sheet 1, i want it to automatically fetch the corresponding figure in colunm B on Sheet 3 for 22 into Cell 1 E??

What formula do i need to use???

Please help

Thanks
Related:

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
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!
0
Ok, that is great, but once that number has been inserted there is a corresponding amount on sheet 3 which needs to automatically be pulled though on my sheet 1

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.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 2, 2012 at 06:18 PM
You need to use VLOOKUP function
0