Forum Discussion
Pull cells by inputting numbers
Hello, i am not to experienced with excel and am trying to find a formula to pull a cells information into another cell by inputting a number into a 3rd cell. ill give a small example.
so if i input a number into column 1 it will find that number in column 2 and output the number from column 3 into column 4.
column 1 row 1 i input 12 so it will find the 12 in column 2 row 2 then output the number next to it in column 3 row 2 into column 4 row 1 output box.
| Column 1 | Column 2 | Column 3 | Column 4 |
| 12 | 11 | 4 | output |
| 16 | 12 | 5 | output |
| 13 | 13 | 6 | output |
| 11 | 14 | 7 | output |
| 15 | 15 | 8 | output |
| 18 | 16 | 9 | output |
| 19 | 17 | 10 | output |
| 12 | 18 | 11 | output |
| 15 | 19 | 12 | output |
Im not sure if this is possible as I am new to excel but this would help me tremendously if someone could give me a way to do this.
Using columns A to D, enter the following formula in D2:
=IFERROR(VLOOKUP(A2, B:C, 2, FALSE), "")
or
=XLOOKUP(A2, B:B, C:C. "")
Fill or copy down from D2.
- Thank you so much this will help me out and make this so much easier for me. I really appreciate the quick reply.
