How to have excel paste a value in a specific cell according to another data table

Julio

I'm working with excel 2010,

I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date.

The numeric values of the second table are entirely dependant of the value of its master cell which is H 18. So the only important cell here is H18. Above cell H18 is another cell (F13) containing another date.

enter image description here

The goal is to be able to change the date in cell F13 and that the data belonging to this date written in the calender will be copied automatically into cell H18.

Raystafarian

Use a HLOOKUP

H18 =HLOOKUP($F$13,$D$6:$Q$7,2,0)

Change the D6:Q7 to wherever your first table ends.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Excel or Google forms - How to identify a specific cell on a table and update value from another worksheet data

From Dev

Excel VBA: How to paste a value in the first Cell of the last row of a table?

From Dev

How to filter the table and paste the value in another sheet in Excel VBA

From Dev

Excel: How to have an IF function return the value of the cell from another sheet

From Dev

Excel how to look for value in table and return value from another cell

From Dev

Copy data from a table in Excel and paste it into another

From Dev

How to cut and paste specific text from one cell to another in Excel 2013 based on a keyword?

From Dev

How to change a formula according to cell value in excel?

From Dev

How to use python to append data to specific cell to existing excel table?

From Dev

Excel IF Formula varififying one cell has data and another cell has specific value

From Dev

How to sum excel data in another worksheet, using the value of a reference cell

From Dev

How to Copy paste a cell Value, if Cell contain more than 0 then paste to another cell by loop

From Dev

How to Copy and Paste Rows starting from a specific cell in another sheet

From Dev

Excel- How to only copy and paste a "specific" string value from one column to another column?

From Dev

Change Value of Excel Cell when another cell contains specific character

From Dev

How to sort json data according to specific value?

From Dev

how to show data according to specific value

From Dev

From ms access table how to paste required data form array (getrows) to excel specific ranges using vba

From Dev

Copying cell values from one sheet to another, and paste it near a cell with specific value

From Dev

VBA Excel - copy cell values and paste value in between characters of another cell

From Dev

Excel - How to use the value of a cell as the row value of another cell?

From Dev

Copy specific cell in column and paste in another worksheet

From Dev

how to copy multiple row to another sheet in specific cell based on value excel VBA

From Dev

Highlight table rows that have max value in a specific cell

From Dev

How can I retrieve a specific cell value from another Excel sheet using this complex logic that find the row using another value?

From Dev

Copy data to a specific cell range on another worksheet in excel

From Dev

How to Copy and paste to another worksheet if value match - Excel VBA

From Dev

How to format a cell based on another cell value in Excel?

From Dev

How to make the value of one Cell as a position of another Cell in Excel

Related Related

  1. 1

    Excel or Google forms - How to identify a specific cell on a table and update value from another worksheet data

  2. 2

    Excel VBA: How to paste a value in the first Cell of the last row of a table?

  3. 3

    How to filter the table and paste the value in another sheet in Excel VBA

  4. 4

    Excel: How to have an IF function return the value of the cell from another sheet

  5. 5

    Excel how to look for value in table and return value from another cell

  6. 6

    Copy data from a table in Excel and paste it into another

  7. 7

    How to cut and paste specific text from one cell to another in Excel 2013 based on a keyword?

  8. 8

    How to change a formula according to cell value in excel?

  9. 9

    How to use python to append data to specific cell to existing excel table?

  10. 10

    Excel IF Formula varififying one cell has data and another cell has specific value

  11. 11

    How to sum excel data in another worksheet, using the value of a reference cell

  12. 12

    How to Copy paste a cell Value, if Cell contain more than 0 then paste to another cell by loop

  13. 13

    How to Copy and Paste Rows starting from a specific cell in another sheet

  14. 14

    Excel- How to only copy and paste a "specific" string value from one column to another column?

  15. 15

    Change Value of Excel Cell when another cell contains specific character

  16. 16

    How to sort json data according to specific value?

  17. 17

    how to show data according to specific value

  18. 18

    From ms access table how to paste required data form array (getrows) to excel specific ranges using vba

  19. 19

    Copying cell values from one sheet to another, and paste it near a cell with specific value

  20. 20

    VBA Excel - copy cell values and paste value in between characters of another cell

  21. 21

    Excel - How to use the value of a cell as the row value of another cell?

  22. 22

    Copy specific cell in column and paste in another worksheet

  23. 23

    how to copy multiple row to another sheet in specific cell based on value excel VBA

  24. 24

    Highlight table rows that have max value in a specific cell

  25. 25

    How can I retrieve a specific cell value from another Excel sheet using this complex logic that find the row using another value?

  26. 26

    Copy data to a specific cell range on another worksheet in excel

  27. 27

    How to Copy and paste to another worksheet if value match - Excel VBA

  28. 28

    How to format a cell based on another cell value in Excel?

  29. 29

    How to make the value of one Cell as a position of another Cell in Excel

HotTag

Archive